P0lar
Member
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 help gratefully appreciated as I keep ending up in monstrous rows of nested Mid() formulas at the minute!
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 help gratefully appreciated as I keep ending up in monstrous rows of nested Mid() formulas at the minute!