Cancelled

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.

Skills: Data Entry, Data Processing, Excel, Web Scraping, Web Search

See more: 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

About the Employer:
( 21 reviews ) Zollikon, Switzerland

Project ID: #15858659

97 freelancers are bidding on average $27 for this job

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 More

$34 USD in 1 day
(563 Reviews)
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 More

$30 USD in 1 day
(466 Reviews)
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 More

$20 USD in 1 day
(221 Reviews)
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 More

$30 USD in 1 day
(317 Reviews)
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 More

$30 USD in 1 day
(242 Reviews)
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 More

$25 USD in 0 days
(213 Reviews)
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 More

$30 USD in 3 days
(143 Reviews)
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 in 1 day
(470 Reviews)
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 More

$25 USD in 1 day
(359 Reviews)
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, More

$15 USD in 1 day
(177 Reviews)
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 in 0 days
(185 Reviews)
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 More

$30 USD in 1 day
(244 Reviews)
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 More

$30 USD in 3 days
(192 Reviews)
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 More

$30 USD in 10 days
(280 Reviews)
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 More

$30 USD in 1 day
(77 Reviews)
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 More

$30 USD in 1 day
(135 Reviews)
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+ More

$35 USD in 2 days
(270 Reviews)
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 More

$30 USD in 1 day
(106 Reviews)
6.1
$25 USD in 1 day
(69 Reviews)
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 More

$150 USD in 1 day
(103 Reviews)
6.1