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