Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parseing Text strings
I need to take a text string that has a Stock Option description in a
text string (i.e. ADM Dec 2006 40.0000 put). I want to divide up the text string and have each word in its own cell. I can not figure out how to do it. Problems arise b/c the stock symbol can have one to four characters (i.e. X or MSFT). What is the best way to do it so it automatically does it? I would prefer to use some sort of function that counts the spaces and gives the next word or something like that. DM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
Finding text strings in complex situations | Excel Discussion (Misc queries) | |||
Searching for codes in text strings | Excel Worksheet Functions | |||
space between text strings with concatenate | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |