Separate City State and Zip in EXCEL file

IT & Networking Database Administration Posted 3 years ago

Fixed Price

Delivery by March 2, 2013




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.

  • Other Skills:

Activity on this Job

Last Viewed by Client: 3 years ago

Invites Sent: 0

Unanswered Invites: 0

Hired: 1

About the Client

(5.00) 4 reviews

United States
Austin 07:12 AM

7 Jobs Posted
72% Hire Rate, 1 Open Job

$381 Total Spent
10 Hires, 0 Active

Member Since Mar 1, 2013