Đã Hủy

Text to columns advanced (several contacts in one field need to be separated)

We have a table with several columns like: real estate property address, city and "contact". In the "contact"-column we have contact details for several persons: firstname, last name, phone no and e-mail.

We need to have one line per contact, but all contact need to have the relevant information, e.g.

----

300 Fifth Ave; New York; [url removed, login to view]@[url removed, login to view] Test/+1 98838 [url removed, login to view]@[url removed, login to view] Test/+1 98838 3777344

----

We used / to separate contact details and --- to separate contacts

The line above should become TWO lines:

300 Fifth Ave; New York; [url removed, login to view]@[url removed, login to view];Michael Test;+1 98838 3777333

300 Fifth Ave; New York; [url removed, login to view]@[url removed, login to view] Test/+1 98838 3777344

The table has roughly 5000 lines.

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel, Web Scraping, Tìm kiếm web

Xem thêm: how to split a single cell in excel, how to split cells in excel 2013, how to split a single cell in excel 2010, how to split one cell into two cells in excel 2007, by using flash fill in the two new columns split the data in column b, how to split a cell in excel 2007 into two, how to divide a cell in excel into two rows, how to split one cell into two in excel 2010, write a c++ program to accept 10 or more numbers then: display the numbers in two columns: one column with the numbers as they w, write a c program to accept 10 or more numbers then display the numbers in two columns one column with the numbers as they were , i need someone to write an article for me for a newspaper column in sydney, filter table in, need facebook 5000 friends, address field need excel, magento advanced search field

Về Bên Thuê:
( 19 nhận xét ) Zollikon, Switzerland

Mã Dự Án: #15858659

103 freelancer đang chào giá trung bình $27 cho công việc này

jaylancer43

Expert Excel Programmer on [url removed, login to view] and have been featured by the freelancer community [url removed, login to view]) Relevant Skills and Experience I am an En Thêm

$34 USD trong 1 ngày
(525 Đánh Giá)
8.1
jhliuster

Hi sir, I have had a look on this project description, I can do this project for you, wait for your reply, I can start work now, 1 day or less time, thanks. Nathan. Relevant Skills and Experience excel Proposed Miles Thêm

$30 USD trong 1 ngày
(414 Đánh Giá)
7.9
FINGERRPRINT

Hi there, we have experience in excel formula's . it can be done quickly. we gone through the requirement , and understood well. hope you would consider our bid. Thank you Relevant Skills and Experience excel formula Thêm

$30 USD trong 1 ngày
(300 Đánh Giá)
7.9
nikhil08

Hi there, Expert here. I have experience of formatting data to excel. I have checked sample listings given, its easy task for me. Relevant Skills and Experience I have experience of formatting data in excel. Proposed Thêm

$20 USD trong 1 ngày
(199 Đánh Giá)
7.5
schoudhary1553

Greeting, I have understood your Text to columns advanced task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Thêm

$30 USD trong 1 ngày
(220 Đánh Giá)
7.3
saqibmunir55

sure i can separate right now send me file Relevant Skills and Experience sure i can separate right now send me file Proposed Milestones $14 USD - sure i can separate right now send me file

$14 USD trong 1 ngày
(396 Đánh Giá)
7.0
hdlong66

Hello, You need to separate several contacts in one field. I can handle this job. Best regards, Hoang Relevant Skills and Experience Excel & Data processing Proposed Milestones $30 USD - Separate several contacts in Thêm

$30 USD trong 3 ngày
(134 Đánh Giá)
6.9
SBITServices

Hello , I have read your project description and understood your requirement. I am an excel Expert can do this task manually or automatically . I can complete task within time with 100% accuracy. Relevant Skills and E Thêm

$25 USD trong 1 ngày
(286 Đánh Giá)
7.1
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experi Thêm

$30 USD trong 3 ngày
(180 Đánh Giá)
6.7
rangacbe

Hi sir, I can do this project with quality. Awaiting your positive response to start asap. Regards, Jaikumar Relevant Skills and Experience Data entry,data processing and all related tasks. Proposed Milestones $30 Thêm

$30 USD trong 10 ngày
(273 Đánh Giá)
6.7
deepabittu

Hello Sir, I have 5+ member team i am done this type job last time with good result so plz give me one chance so i am done this job with good [url removed, login to view] Regards Relevant Skills and Experience Hello Sir, I have 5+ Thêm

$35 USD trong 2 ngày
(255 Đánh Giá)
6.6
semi786

Hi Sir/Mam, It is being my pleasure to introduce you to me. I am expert in advance excel. I can do this job very easily. I am familiar with this task and I will start immediately and complete soon. Relevant Skills an Thêm

$25 USD trong 0 ngày
(117 Đánh Giá)
6.5
flashsaiful

i understand your project you need to first name, last name, phone no and e-mail Data collect it's very simple work, i can do this please contact me thanks Relevant Skills and Experience Data Entry, Data Processing, Thêm

$15 USD trong 1 ngày
(177 Đánh Giá)
6.8
BithiXpert

Hello Dear, I am an expert in Data Entry, Data Processing, Excel, and I am really interested in your project. I work efficiently and will finish in a timely manner and will provide high quality work Relevant Skills an Thêm

$30 USD trong 1 ngày
(222 Đánh Giá)
6.6
priyal1997

Hi There, Just send me the file, I will first do it, if you are done, you can offer me the project later. Tnx Priyal Relevant Skills and Experience Excel Proposed Milestones $30 USD - cost

$30 USD trong 0 ngày
(171 Đánh Giá)
6.6
Tanmoy236

I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work Relevant Skills an Thêm

$30 USD trong 1 ngày
(107 Đánh Giá)
6.2
onlinejob247

Hi there, I have read the details and lots of experience Text to columns advanced and different types of projects. I am waiting for your quick positive reply. Relevant Skills and Experience Data Entry, Data Processin Thêm

$30 USD trong 1 ngày
(56 Đánh Giá)
5.8
Rajni0802

Hello Employer, we can manage this task of separating contact details in columns for the real estate data as instructed in project description Relevant Skills and Experience we're skilled in excel formatting tasks Pr Thêm

$150 USD trong 1 ngày
(98 Đánh Giá)
6.0
abedin94

hello , I am SID . i am a software engineer since 2012 . By working there i have gathered immersive knowledge in Java,Python, android ,scrapping . knock me and get the work done . Relevant Skills and Experience Data Thêm

$30 USD trong 0 ngày
(64 Đánh Giá)
5.8
$25 USD trong 1 ngày
(63 Đánh Giá)
5.9