Thank you for your reply
Could you please describe more on how to do it?
Thank & Regards
Eric

"Dave Peterson" wrote:

You could use Data|Text to columns.
Delimited by space
and check the Treat consecutive delimiters as one



Eric wrote:

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

--

Dave Peterson