Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.misc
|
|||
|
|||
How to retrieve certain text from string?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve certain text from string?
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve certain text from string?
Why not try starting from the "Data" menu, and see whether you can work it
out from there? -- David Biddulph "Eric" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve certain text from string?
Thank you
Eric "David Biddulph" wrote: Why not try starting from the "Data" menu, and see whether you can work it out from there? -- David Biddulph "Eric" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve certain text from string?
To Eric - I read an older note of yours in a different place about a
sound problem - sound turning itself off mysteriously. I've been having this sound problem. A full Norton Ghost restore fixed it for a few days. I need to be able to get the sound back easier. On Windows XP I don't see windows sound in the system tools. Any info? thanks Eric wrote: Thank you Eric "David Biddulph" wrote: Why not try starting from the "Data" menu, and see whether you can work it out from there? -- David Biddulph "Eric" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieve text content from range with criteria | Excel Worksheet Functions | |||
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 |