How do I split addresses(city, state,zip)?
 

I am trying to print labels but I have a spreadsheet with about 1200
addresses that are not separated.

How do I split addresses(city, state,zip)?
 

Makes sure all as many columns as you want to split this into are empty to
the right

select the column, then do datatext to columns and select commas as
delimiter.



--


Regards,


Peo Sjoblom

"newbie101" wrote in message
...
I am trying to print labels but I have a spreadsheet with about 1200
addresses that are not separated.