SEARCH

The How-To Geek Forums Have Migrated to Discourse



Join the Discussion at discuss.howtogeek.com

How-To Geek Forums / Microsoft Office

Split address field into separate columns in Excel

(4 posts)
  • Started 4 years ago by goodguy
  • Latest reply from raphoenix
  • Topic Viewed 13117 times

goodguy
Posts: 9

I have a spreadsheet with 1000s of records.
How do I split the address field into 4 separate columns in Excel i.e. Address, City, State and Zip?

4325 Rockville Av
Wilmington DE 31710

Thanks

Posted 4 years ago #
Top
 
whs
whs
Posts: 17584

Here are a couple of methods I found on the web. Maybe they help:

http://en.allexperts.com/q/Exc.....parate.htm

http://www.sleeter.com/kbase/kbarticles/1099961389

Posted 4 years ago #
Top
 
goodguy
Posts: 9

I found the first method earlier. I dont know how to implement the suggestion and dont want to pay $45 an hour for a resolution.
The second method I can do but doesnt go far enough to help.

Posted 4 years ago #
Top
 
raphoenix
raphoenix
Posts: 14920

goodguy,

There are 3 ways to do the task which I know of.

1. Re-enter the data manually.
2. Make complicated formulas in other cells.
3. Write a macro.

Best bet, with that much info to transform, is get a good book on Excel.

One of our members may have had to do this before since it is a very, very common error, so maybe they will respond with the formula or macro they used so you can started.

Kindest Regards,
Rick P.♦ :)

Posted 4 years ago #
Top
 



Topic Closed

This topic has been closed to new replies. Please create a new topic instead.


Create New Topic Return to Forum