How to split a value seperated by comma?

Hi - I didn't know the best way to describe this in the title of the post - but here's the situation:

I have a column of values that are two text strings seperated by a comma. For example:

Blue Widgets, DVD
Blue Widgets, Movies
Blue Widgets, Books
Red Widgets, Tips
Red Widgets, Format

And so on.... What I need is to split that into two columns, with the values "blue widgets" and "dvd" for example. Basically the comma always seperates the values. What excel formula could I use? I know it's possible but it's a bit beyond my excel wizardry

Go to Data menu, and choose text to columns. If you want it kept as you see it, choose fixed width. If you choose comma delimited, it will assign columns for each field. Choose how you want it allocated, it will give you a preview, if that is how you want it click FINISH.

You have two options.

I. Data->Text to columns
Select Delimited and click next.
Check comma, uncheck everything else.
Click on Finish
Select the second column and do a find-replace finding " " (space bar) and
replacing it with nothing (leave blank). This will remove the first blank in
each cell of that column.

II. Use the following formulas and then cut and paste special selecting
values.
=LEFT(A1,FIND(",",A1)-1)
=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)

Hope this helps


"Ticktockman" wrote:

>
> Hi - I didn't know the best way to describe this in the title of the
> post - but here's the situation:
>
> I have a column of values that are two text strings seperated by a
> comma. For example:
>
> Blue Widgets, DVD
> Blue Widgets, Movies
> Blue Widgets, Books
> Red Widgets, Tips
> Red Widgets, Format
>
> And so on.... What I need is to split that into two columns, with the
> values "blue widgets" and "dvd" for example. Basically the comma
> always seperates the values. What excel formula could I use? I know
> it's possible but it's a bit beyond my excel wizardry
>
>
> --
> Ticktockman
> ------------------------------------------------------------------------
> Ticktockman's Profile: http://www.excelforum.com/member.php...o&userid=32740
> View this thread: http://www.excelforum.com/showthread...hreadid=525715
>
> Sloth March