software

Hi have a cell that has the folowing string quot;Martini Glass, Appletiniquot; and I
need to turn this one cell into two cells by finding the comma and taking
everythign after that to place it into another cell. So the value would be
quot;Martini Glassquot; in one cell and quot;Appletiniquot; in another.

HELP!

The best way if you always want to split where the comma is would be to use
datagt;text to columns, select delimited, click next, select comma as
delimiter and click finish. Just make sure the column(s) to the right are
empty or they will be overwritten

Otherwise

=LEFT(A1,FIND(quot;,quot;,A1)-1)

and

=MID(A1,FIND(quot;,quot;,A1) 2,255)

or better

=TRIM(MID(A1,FIND(quot;,quot;,A1) 1,255))

just in case there might or not be spaces involved

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;XMLCimoquot; gt; wrote in message
...
gt; Hi have a cell that has the folowing string quot;Martini Glass, Appletiniquot; and
gt; I
gt; need to turn this one cell into two cells by finding the comma and taking
gt; everythign after that to place it into another cell. So the value would be
gt; quot;Martini Glassquot; in one cell and quot;Appletiniquot; in another.
gt;
gt; HELP!