How to extract just text from cells
PERFECT - THANKS!
"ryguy7272" wrote:
Try this:
=MID(A15,SUMPRODUCT(--ISNUMBER(--MID(A1,ROW($1:$999),1)))+1,999)
Regards,
Ryan--
--
RyGuy
"Access Joe" wrote:
Hi all,
I want to extract only TEXT from a column of numbers and text. For example:
WHAT I HAVE:
150mgdl
2000mg
10mgdl
500cc
WHAT I WANT:
mgdl
mg
mgdl
cc
is there a function in Excel that does this and extracts only the text, not
the numbers?
Thanks everyone!
|