Separate City State and Zip in EXCEL file

IT & Networking Database Administration Posted 2 years ago

Fixed Price

Delivery by March 2, 2013

$10.00

Budget

Details

I have about 1900 names and addresses in an EXCEL file. I need headers added above each column and the city, state and zip codes placed into separate columns.

My information is currently in the following columns without headers: (COLUMN 1) John Doe, (COLUMN 2) Or Current Resident, (COLUMN 3) 123 Main Street, (COLUMN 4) Any Town NJ 55555

I need the information in the following columns (with the following headers)...(COLUMN 1 "Name") John Doe, (COLUMN 2 "Or Current Resident") Or Current Resident, (COLUMN 3 "Street Address") 123 Main Street, (COLUMN 4 "City") Any Town, (COLUMN 5 "State") NJ, (COLUMN 5 "Zip" - TEXT format...NOT zip code format) 55555

That's it...NO COMMAS -- after state, please.

Skills Required:

Client Activity on this Job

Last Viewed: 2 years ago

Applicants: 17

Hired: 1


About the Client

(5.00) 4 reviews

United States
Austin 03:39 AM

7 Jobs Posted
72% Hire Rate, 1 Open Job

$381 Total Spent
10 Hires, 0 Active

Member Since Mar 1, 2013