Đã 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; [login to view URL]@[login to view URL] Test/+1 98838 [login to view URL]@[login to view URL] 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; [login to view URL]@[login to view URL];Michael Test;+1 98838 3777333

300 Fifth Ave; New York; [login to view URL]@[login to view URL] 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 nhiều hơn: 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ê:
( 21 nhận xét ) Zollikon, Switzerland

ID dự án: #15858659

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

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En Thêm

$34 USD trong 1 ngày
(563 Nhận xét)
8.2
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
(466 Nhận xét)
8.0
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
(221 Nhận xét)
7.7
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
(317 Nhận xét)
8.0
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
(242 Nhận xét)
7.5
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
(213 Nhận xét)
7.1
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
(143 Nhận xét)
6.9
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
(470 Nhận xét)
7.2
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
(359 Nhận xét)
7.3
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ận xét)
6.8
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
(185 Nhận xét)
6.7
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
(244 Nhận xét)
6.8
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
(192 Nhận xét)
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
(280 Nhận xét)
6.7
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
(77 Nhận xét)
6.1
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
(135 Nhận xét)
6.3
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 [login to view URL] Regards Relevant Skills and Experience Hello Sir, I have 5+ Thêm

$35 USD trong 2 ngày
(270 Nhận xét)
6.6
leelakalidas32

Hello, i am Ajay from India without wasting our both time i want to work for your sample file for selection for this [login to view URL] allow me to start sampling .contact me anytime i am always here Relevant Skills and Thêm

$30 USD trong 1 ngày
(106 Nhận xét)
6.1
$25 USD trong 1 ngày
(69 Nhận xét)
6.0
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
(103 Nhận xét)
6.1