Lukket

Excel .xlsx Customer database to modify columns

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 .

and

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!

Færdigheder: Dataindførsel, Excel, Windows Skrivebord

Se mere: services database, microsoft project import, microsoft phone number, microsoft excel software, excel &, database entry software, customer it, act on software, access database services, modif xlsx, customer database columns, new excel, excel split columns, access database on sharepoint, customer database in excel, xlsx, sharepoint services, import excel, import database, excel\ , excel, excel services, excel c#, email customer, database to excel

Om arbejdsgiveren:
( 0 bedømmelser ) North Miami Beach, United States

Projekt-ID: #284870

85 freelancere byder i gennemsnit $277 for dette job

elinksol

Hello sir, Thanks for providing us a chance to bid. Our experties are very much in line to your requirements. WE are old dataBase developers. Our Experties are in DataBase applications are top level. We also have data Mere

$350 USD in 5 dage
(223 bedømmelser)
7.4
ggopi

Lets start immediately.

$250 USD på 1 dag
(203 bedømmelser)
6.5
MAnkita

Hello,Please refer your [url removed, login to view] you.

$250 USD på 1 dag
(82 bedømmelser)
6.2
vinodnaughty

Hello Sir, I feel very interested, please check my PM. Thanx. Vinod

$250 USD in 7 dage
(123 bedømmelser)
6.0
spawar

Hi, I'm ready to do this work now, and will provide you the two output file, one is xls format, and 2nd is access format, I've 12 years experience in a software development, I've downloaded the sample work, but its Mere

$250 USD in 3 dage
(47 bedømmelser)
5.9
teenasethi

hi, I am experienced in Excel Work, please check my PM. Thanks

$275 USD in 3 dage
(83 bedømmelser)
5.6
SouthIndian

Please refer PMB. Thanks.

$250 USD på 1 dag
(133 bedømmelser)
5.7
nishmeh

Please check the PMB.

$250 USD på 1 dag
(35 bedømmelser)
5.4
maribel1218

Dear Sir and Ma'am Greetings! Kindly refer to PM for details of my bid. Thank you

$250 USD in 3 dage
(20 bedømmelser)
5.1
viya89809

Check PM...

$250 USD in 0 dage
(28 bedømmelser)
5.1
StaciD930

Please see PMB. Thank You!

$250 USD in 0 dage
(26 bedømmelser)
5.0
ioanaprof

Hello, We can provide a quality work at a low price, Best regards

$250 USD in 2 dage
(19 bedømmelser)
4.8
evrk

Hi, I wish to work with this project. Please have a look at Message Board. Thanks

$250 USD in 2 dage
(39 bedømmelser)
4.6
linkcombd

Please Check your PMB.

$250 USD på 1 dag
(4 bedømmelser)
3.7
divyapeddi

Hi, Please check PM. Thanks, Divya.

$400 USD in 7 dage
(25 bedømmelser)
3.7
trans3

Please check PM for more information. Thanks.

$250 USD på 1 dag
(11 bedømmelser)
3.6
JustPlainBill

Hello Guscas. Please See the Private Message I am about to leave you. Bill

$250 USD på 1 dag
(20 bedømmelser)
3.6
wahabltd

Please check PM for the right bid.

$250 USD in 3 dage
(7 bedømmelser)
3.5
Mainstream4

Please, check PM.

$250 USD på 1 dag
(1 bedømmelse)
3.4
softwaredep

See PMB for more inforamtion. Thank you.

$750 USD in 6 dage
(4 bedømmelser)
2.9