Hi have a cell that has the folowing string "Martini Glass, Appletini" 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
"Martini Glass" in one cell and "Appletini" in another.

HELP!

The best way if you always want to split where the comma is would be to use
datatext 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(",",A1)-1)

and

=MID(A1,FIND(",",A1)+2,255)

or better

=TRIM(MID(A1,FIND(",",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




"XMLCimo" wrote in message
...
Hi have a cell that has the folowing string "Martini Glass, Appletini" 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
"Martini Glass" in one cell and "Appletini" in another.

HELP!