Hi,
I have a list of about 6000 records which are a mixture of text and numbers. the string is either: Numbers, text, numbers, text or: Text, numbers, text or: Text, numbers. I need to write a formula (or UDF) to remove the last (right hand side) text from all the records which have it.
Any...