| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retrieve certain text from string? | Excel Discussion (Misc queries) | |||
| How do I retrieve the text string from the right of a cell | Excel Worksheet Functions | |||
| How do I grab the date from a text string? | Excel Worksheet Functions | |||
| Find & Replace text format | Excel Discussion (Misc queries) | |||
| Text string and sum | Excel Worksheet Functions | |||
Linear Mode
