Opposite of Concatenate (Breaking apart a string)

X

XMLCimo

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!
 
P

Peo Sjoblom

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