I have a Excel .xlsx file, customers list with 3400 customers.
I need to split the information inside the column "Agency Address" wich is split in 3 rows now and contains the complete address, into new individual columns for 1) "Address", 2) "City", 3) "Zip",4) "State" and 5) "County".
On the "Agency Phone Number" column need to split in 2 and add the Fax Number" into a new "Fax Number" column .
The column "Agent Name" needs to be split in two, adding the "Email" in a new "Email" column.
I need the lists to be able to import to Email program like "The Bat" and ACT! customer software. and SharePoint services using Microsoft Access.
I'm attaching 2 sample files.
The first is a sample of the original existing file. and the second attachment is the file as I would be needing it. (final result)
I need the project finish urgently!