You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Divide Address into separate columns

Divide Address into separate columns

Price: FREE

I need to take the following data in a single cell .
248 Twenty first St, Denmark SA 5341
and change it into this.
248 Twenty first St | Denmark | SA | 5341 |
So I end up with 4 columns. What I have been doing up to now is copy the column with data into a text file, then import back using spaces as delimiters, then I spend a heap of time fixing the errors.
Presume the data is in column A, Is there a way to put the postcode into column D, the State into Column C, the name into column B and leave the address in column A? - Wow! this would help so much, I have 100's to do! - Maybe I need to use the spaces as identifiers?
I did manage to move the postcode across. but I keep getting lost when I need to get more specific. Any help would be appreciated heaps!

Visit publisher's web-site: Divide Address into separate columns

Category and Tags: ExcelTutorials :

Related Tutorials

divide address into 2 columns

Free: Yes
Tags: Excel ›

I have a list of addresses in one column of excel in the format : 123 Main St, Litigant, PA 17543 and I want to know how to separate this data into 2 columns, one column with just the address and the next with city, state, zip

Put each data into separate columns?

Free: Yes
Tags: Excel ›

I would like to know how to separate each individual data into separate columns. I copied the results from a website and I would like them to be separated without hassling too much time. I have like 250 companies to separate and it was a hassle to move them into separate columns. The sample goes like this:
From the data (all in one column):
(Company Name)
(Company Address)
(Company City)
(Company Phone No.)
(Company Owner)
And what I would want to transfer into separate columns:
(Company Name) | (Company Address) | (Company City) | (Company Phone No.) | (Company Owner)
I'll take a screenshot later tonight when I get off from work. I would gladly appreciate it.

Separate address numbers from street name

Free: Yes
Tags: Excel › Functions

I would like to separate the street number from the street name.
Currently I have a large database with one column with an address displayed as: 108 Delmar
I would like to keep this column but would like to have the number and the street name set up in two new columns

Extract UK address into seperate cells

Free: Yes
Tags: Excel ›

I have c 500 address which I need to separate into separate cells for the purpose of a mail merge.
I have attached an excel spreadsheet with all the addresses in and have managed to extract the first line of the address using the LEFT function.
I reckon I can work out how to get the postcode but don't know how to separate the middle (towns, counties) etc.

How do I separate data in address field?

Free: Yes
Tags: Excel ›

I have over 1,00 records in an address data base. The street address field contains both the house number and the street name. I need to place these in separate fields so that I can sort by street name. Is there a shortcut to doing this so that I don't have to cut and paste each individual record?

Related Applications & Scripts

Reverse IP Look-up

Free: Yes
Tags: Web Services › Excel DNS

This tool searches for domain names hosted on your IP address. Just enter a domain or an IP address to get a list of domain names that share the same IP address.

IP address to location

Free: Yes

Free tool that shows the location of IP address, domain or hostname. It uses Maxmind GeoLite city database for the purpose of finding IP location) and Google maps API for creating the world map.

Reverse Geocoder (GPS Coordinates to Address)

Free: No
Tags: Flash › Excel Geolocation Google Maps

An easy to use class that uses Google Maps API to perform reverse geocoding: convert latitude & longitude GPS coordinates into the corresponding street address.
Just add the files into your project, and start reverse geocoding with just 3 lines of code!

Verify email address

Free: Yes
Tags: PHP › Excel Validation

Verifies that a string looks like a real email address. It may return false for some valid exotic email addresses. To correct this you may want to edit validate-string to accept more characters.

myFriends: Address Book

Free: Yes
Tags: PHP › Excel Organizers

myFriends is a small program for those who have Apache WEB server and mySQL database up and running. It is an address list using a WEB interface. Features include: Storing all relevant information like name, address, e-mail for home and work, Maintaining family relationships (children, parents, spouses), Connect arbitrary number of structured information to each person on the list (Notes, Dates, and Flags), Produce sorted lists for printing or CSV lists for spreadsheets, and more.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing