Exclude numbers for cell that also has Text

[Mathman]

If I have the following all in cell A1


40 2 Apples and oranges


How do I just get Apples and Oranges


also the text could have varying number of text and the numbers at the beginning can also change to varying degrees.

Thank you
MM
​

 

[Special-K99]

Supply some more data so we can distinguish a pattern.
Vary the examples according to your data.

 

[Rick Rothstein]

Here is an array-entered** formula that should work...

=REPLACE(A1,1,MIN(IF(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))>64,ROW(INDIRECT("1:"&LEN(A1)))))-1,"")

**Commit this formula using CTRL+SHIFT+ENTER and not just Enter by itself

 

[Mathman]

Wow Rick, you've done it again! Although I have no idea what you did, it seems to work perfectly!


Thanks again for your help!
MM​