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!