software

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 quot;blue widgetsquot; and quot;dvdquot; 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: www.excelforum.com/member.php...oamp;userid=32740
View this thread: 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: www.excelforum.com/member.php...oamp;userid=32737
View this thread: www.excelforum.com/showthread...hreadid=525715You have two options.

I. Data-gt;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 quot; quot; (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(quot;,quot;,A1)-1)
=RIGHT(A1,LEN(A1)-FIND(quot;,quot;,A1)-1)

Hope this helpsquot;Ticktockmanquot; wrote:

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