View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
XMLCimo
 
Posts: n/a
Default Opposite of Concatenate (Breaking apart a string)

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!