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