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