ExcelBanter - How to retrieve certain text from string?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to retrieve certain text from string? (https://www.excelbanter.com/excel-worksheet-functions/121318-how-retrieve-certain-text-string.html)

Eric

How to retrieve certain text from string?

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

Rob

How to retrieve certain text from string?

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

Eric

How to retrieve certain text from string?

Thank you
Eric

"Rob" wrote:

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

All times are GMT +1. The time now is 02:56 PM.