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
|