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

N

newbie101

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

Peo Sjoblom

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

select the column, then do data>text to columns and select commas as
delimiter.



--


Regards,


Peo Sjoblom
 
Top