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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Address Format changed after Migration 0
Anything will help 0
Blank Page After Envelope-Label Wizard 5
Split data in cells 1
How to use matching values in two worksheets to return another value 5
Text to column using multiple spaces?? CITY STATE ZIP 2
Autofill a city and state from a zipcode 7
How to print labels from excel 1

Top