View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default 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.