Text String Seperation.

  • Thread starter Thread starter db_murray
  • Start date Start date
D

db_murray

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.

I realize I can use the Text-to-columns but I really want to automate
tha step so the uses of my spreadsheet dont have to go deeper than the
first worksheet.


DM
 
Same people monitor this news group as excel.misc where you received a few
answers.

No point in posting the same question more than once.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parseing Text strings 8
text string 2
sumproduct - find text in string 11
Return the text before a | in a text string 5
Is there a function that will evaluate a text string in a cell? 2
How do you use the equivalent of NOT in text? 2
Nested formula to search a text string and return specific text 10
Sorting a text strings but omitting preceding "A" or "The" 2

Back
Top