Forum Discussion
extracting text after the last : in a text field
I have a series of account number sin excel like 030.40 OVERHEADS / EXPENSES:SELLING / MARKETING OVERHEADS:EMPLOYEE EXPENSES:Superannuation 030.40 OVERHEADS / EXPENSES:SELLING / MARKETING OVER...
You "count" the occurrences of ":" and get the last one. Here's the first example I found on google: https://stackoverflow.com/questions/18617349/excel-last-character-string-match-in-a-string
thank you Vasil
that is a perfect answer
