İptal Edildi

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.

Beceriler: Veri Girişi, Veri İşleme, Excel, Web Scraping, İnternet Araştırması

Daha fazlasını gör: 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, 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, data entry, data processing, excel, visual basic, web scraping, web search, visual basic for apps, microsoft excel, filter table in

İşveren Hakkında:
( 21 değerlendirme ) Zollikon, Switzerland

Proje NO: #15858659

Bu iş için 96 freelancer ortalamada $27 teklif veriyor

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(625 Değerlendirme)
8.3
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(505 Değerlendirme)
8.1
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(242 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(328 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(287 Değerlendirme)
7.7
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(297 Değerlendirme)
7.7
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(433 Değerlendirme)
7.4
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(252 Değerlendirme)
7.0
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(547 Değerlendirme)
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, Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(187 Değerlendirme)
6.9
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

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(187 Değerlendirme)
6.7
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(210 Değerlendirme)
6.8
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(159 Değerlendirme)
7.0
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(169 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(187 Değerlendirme)
6.6
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(281 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(89 Değerlendirme)
6.2
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+ Daha Fazla

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(286 Değerlendirme)
6.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(76 Değerlendirme)
6.3
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(110 Değerlendirme)
6.2