Ditutup

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!

Kemahiran: Pemasukan Data, Excel, Destop Windows

Lihat lebih lanjut: 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

Tentang Majikan:
( 0 ulasan ) North Miami Beach, United States

ID Projek: #284870

85 pekerja bebas membida secara purata $277 untuk pekerjaan ini

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 Lagi

$350 USD dalam 5 hari
(223 Ulasan)
7.4
ggopi

Lets start immediately.

$250 USD dalam sehari
(203 Ulasan)
6.5
MAnkita

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

$250 USD dalam sehari
(82 Ulasan)
6.2
vinodnaughty

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

$250 USD dalam 7 hari
(123 Ulasan)
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 Lagi

$250 USD dalam 3 hari
(47 Ulasan)
5.9
teenasethi

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

$275 USD dalam 3 hari
(83 Ulasan)
5.6
SouthIndian

Please refer PMB. Thanks.

$250 USD dalam sehari
(133 Ulasan)
5.7
nishmeh

Please check the PMB.

$250 USD dalam sehari
(35 Ulasan)
5.4
maribel1218

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

$250 USD dalam 3 hari
(20 Ulasan)
5.1
viya89809

Check PM...

$250 USD dalam 0 hari
(28 Ulasan)
5.1
StaciD930

Please see PMB. Thank You!

$250 USD dalam 0 hari
(26 Ulasan)
5.0
ioanaprof

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

$250 USD dalam 2 hari
(19 Ulasan)
4.8
evrk

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

$250 USD dalam 2 hari
(39 Ulasan)
4.6
linkcombd

Please Check your PMB.

$250 USD dalam sehari
(4 Ulasan)
3.7
divyapeddi

Hi, Please check PM. Thanks, Divya.

$400 USD dalam 7 hari
(25 Ulasan)
3.7
trans3

Please check PM for more information. Thanks.

$250 USD dalam sehari
(11 Ulasan)
3.6
JustPlainBill

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

$250 USD dalam sehari
(20 Ulasan)
3.6
wahabltd

Please check PM for the right bid.

$250 USD dalam 3 hari
(7 Ulasan)
3.5
Mainstream4

Please, check PM.

$250 USD dalam sehari
(1 Ulasan)
3.4
softwaredep

See PMB for more inforamtion. Thank you.

$750 USD dalam 6 hari
(4 Ulasan)
2.9