Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
"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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can excel produce text in a given cell as a result of a boolean operation? | Excel Discussion (Misc queries) | |||
Parseing Text strings | Excel Discussion (Misc queries) | |||
How do I produce a number in parentheses? | Excel Discussion (Misc queries) | |||
produce a formulate to produce assigned seats for dinner | Excel Worksheet Functions | |||
How to produce comma-delimited and quoted text file from Excel? | Excel Discussion (Misc queries) |