Eric,

Would Text to columns work? It can be found under the Data menu

HTH Rob

"Eric" wrote in message
...
Does anyone know how to retrieve certain text from string in excel? for
example,
in cell A1, " 1 abc 18 21", I would like to retrieve the value of
1
in B1, and 18 in C1 without including any space. Does anyone have any
suggestion?
Thank you in advance
Eric