variable "left" formula?

[esponapule]

I am trying to separate text text from a single column and put it into multiple columns.

Here is what I have:

[B]Column A[/B]
Tools|Painting & Supplies|Wall Borders & Appliques
Tools|Painting & Supplies|Weather Stripping
Tools|Personalized Tool Sets|Chests

and here is what I would like it to be:

[B]Column A[/B]       [B]Column B [/B]                    [B]Column C[/B]
Tools          Painting & Supplies          Wall Borders & Appliques
Tools          Painting & Supplies          Weather Stripping
Tools          Personalized Tool Sets       Chests

what would be the best way to do this (if possible) and without a macro??

thanks to all the excel geniuses who help me everyday!

 

[VoG]

Select the data, Data > Text to Columns, specify Delimited, Other as the delimiter and enter | as the delimiter and click Finish.

 

[Jared_8878]

I see they are separated by a |

so go into text to columns and use that as your delimiter

 

[pagrender]

You should be able to use Text to Columns, with a | as the delimiter.

 

[Smitty]

Welcome to the Board!

If "|" is really your delimiter, then you can use Data-->Text to Columns-->Delimited-->Other-->|.

If it's not, what's the delimiter?

 

[esponapule]

that worked perfectly!! and it was so easy!
| was the delimiter...

thanks