ASAP Utilities, a free add-in available at
www.asap-utilities.com includes
this capabaility among it's many nifty features.
Vaya con Dios,
Chuck, CABGx3
"jtoy" wrote in message
...
I'm trying to extract text only from a column of cells with varying text
and
number strings. Sometimes the cell starts with numbers, other times text.
There is no constant for the number at the beginning of the cells.
Assuming all data in column C.
Went through all the functions and couldn't find anything this simple. Or
maybe it's not that simple?
thanks!