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

*-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.-*


--
mrsinnister
------------------------------------------------------------------------
mrsinnister's Profile: http://www.excelforum.com/member.php...o&userid=32737
View this thread: http://www.excelforum.com/showthread...hreadid=525715

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