Parsing out complex string

  • Thread starter Thread starter whit
  • Start date Start date
W

whit

I am in need of a formula to parse out a string of text. Here is what I
am trying to do:

In A1 I have: "a.b.c. red blue green a.b.c. green yellow a.b.c orange
blue green"

I would like to split out the information between the "a.b.c" so that
they are in separate columns.

Any help is appreciated.

Thanks,
Whit
 
Hi,

have you tried using "Text to Columns" from the data menu?
Use "space" as a delimiter. You will also get a column for
each "a.b.c." but you can always delete that out after.

HTH,
John.
 
Text to columns allows you to exclude columns, so in the third pane
of the Text to columns dialog, click in the header of the "a.b.c"
columns and select the Do Not Import (skip) radio button.
 
Back
Top