eg cell contains 1:44. 5/1.(36.44) The text begins here....
There is no common delimiter

What about the closing ")" ?

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(IND IRECT("1:"&LEN(A1))),1))<=90),0),255)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Mick Barry" wrote in message
...
I am looking for a formula which will parse a cell containing both numbers
and then text.
eg cell contains 1:44. 5/1.(36.44) The text begins here....
The resulting formula will produce-The text begins here....
There is no common delimiter

regards Mick
You don't need a parachute to skydive,
You only need a parachute to skydive twice...