View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
plunkettphoto plunkettphoto is offline
external usenet poster
 
Posts: 1
Default Line Breaks in cells - Mac OS X Leopard

Using Excel 2004 for Mac v11.5

I have a spreadsheet delivered to me from a 3rd party which contains an
address list. The address cell has the city state and zip all together in
one cell apparently separated by a line break character because the wrap text
causes the cell to divide into multiple lines with the city state and zip on
separate lines - there are most likely 2 line breaks because there is a blank
line between each data line.

Is there any way to automatically separate the three fields into 3 columns?

thanks,
bill plunkett