The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Split address field into separate columns in Excel

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

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


Posted 7 years ago
Posts: 17584

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

Posted 7 years ago
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 7 years ago
Posts: 14920


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 7 years ago

Topic Closed

This topic has been closed to new replies.