Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Help to return only first 12 characters when a cell contains specific text

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help to return only first 12 characters when a cell contains specific text
Hi Guys, I have a spreadsheet which has some unnecessary characters added onto the end of some records which I need to remove. I am essentially trying to ensure that if a Cell in column A begins with (or contains) "PR" that it only returns the first 12 characters. Other records in column A may...