I wasn't sure what to do about that. The OP said he wanted to extract the
text (non-numbers) and that leading space is text, so I left it in.

Rick


"T. Valko" wrote in message
...
Needs to trim the space in the first example.

--
Biff
Microsoft Excel MVP


"Ron Coderre" wrote in message
...
Certainly better than what I threw together.
(I don't know WHAT I was thinking.)

Ron



"Rick Rothstein (MVP - VB)" wrote
in message ...
Assuming your text is not longer than 999 characters and that your
digits are all next to each other (no leading or intervening spaces or
characters)...

=MID(A1,SUMPRODUCT(--ISNUMBER(--MID(A1,ROW($1:$999),1)))+1,999)

Rick


"Dan S" wrote in message
...
I have a bunch of cell with varying lench that have numbers at the
beginning
(also of varying length. Ex:

1258 ahjKJ yuUIOI
45687045HJKoiuwER

I just want to extract the text from these cell. How do I do that?

Thanks,
Dan