Stripping nubers from text in a cell
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
|