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

I don't use a Mac, but if the cell really contains those alt-enters (line
breaks), I could do this on a wintel machine:

Insert a couple of extra columns to the right of the column with the addresses.
Select the column with the addresses
data|text to columns (xl2003 menus--I don't know on xl2004)
delimited by other
I'd use ctrl-j
(or hold down the alt and hit 0010 on the number keypad)
skip (do not import) the empty fields)
and finish up.

Save your workbook first--so you can close without saving if it screws up your
data (or just use undo???).

You may want to post he
news://msnews.microsoft.com/microsof...c.office.excel
if this suggestion doesn't work.


plunkettphoto wrote:

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

--

Dave Peterson