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

  • Thread starter Thread starter newbie101
  • Start date Start date
N

newbie101

I am trying to print labels but I have a spreadsheet with about 1200
addresses that are not separated.
 
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
 
Back
Top