Parseing to produce text only
"T. Valko" wrote...
eg cell contains 1:44. 5/1.(36.44) The text begins here....
There is no common delimiter
....
As a last resort this array formula** will work if there truly is no
common delimiter *and* the text starts with a letter from a to z:
=MID(A1,MATCH(1,(CODE(MID(UPPER(A1),ROW(INDIRECT( "1:"&LEN(A1))),1))=65)
*(CODE(MID(UPPER(A1),ROW(INDIRECT("1:"&LEN(A1))), 1))<=90),0),255)
....
Picky: this begins at the first letter in the string. That may be what the
OP wants, but the OP's request is ambiguous. Text might begin with the first
letter after the last numeral. And it becomes much harder if the numeric
part could contain letters and the text part embedded numbers.
|