Terminé

Excel - separate data from one column in multiple columns

I have an excel file with 1263 products, there is just one column and I need to separate the name of the products from the CODES of the products, example:

Column 1:

4684T TSA-Accepted Padlock - Set-Your-Own-Combination

Final result should be:

Column 1: 4684T TSA

Column 2: Accepted Padlock - Set-Your-Own-Combination

The codes and products sometimes are not necessarily one after another, so make sure you locate the code within the cell.

I need this done by Monday.

Thanks

Compétences : Excel

en voir plus : how to split numbers in excel, how to split one column into multiple columns in excel, split excel cell into two columns, excel split cell in half, separating data in excel into separate columns, split excel cell into two rows, how to separate numbers in excel using formula, text to rows in excel, I like someone who can scrape data from multiple websites and arrange it in excel, google excel multiple columns column, excel vba combine multiple columns single column, macro combine multiple columns single column excel, separate data rows columns excel, separate data columns hours excel, separate data excel rows columns

Concernant l'employeur :
( 10 commentaires ) Nollamara, Australia

Nº du projet : #15178989

Décerné à:

ksriniravi

I can split the data in Product Name column so that Codes is in one column and Product Names is in another column. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the Plus

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% AUD en 1 jour
(139 Commentaires)
6.5

123 freelance font une offre moyenne de $24 pour ce travail

cgullapalli

Hi, I am good at Data Entry, Excel formula. Looking forward to work on this project. I would like to discuss few rows, as the product code is in the middle of the text. Relevant Skills and Experience Excel, Data Ent Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(676 Commentaires)
7.7
schoudhary1553

Hello Sir, I am the expert freelancer and complete your project as per your expection. please give me a chance to work on your project. Relevant Skills and Experience I have more than 7 years of experience in excel Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(224 Commentaires)
7.4
semi786

Hi Sir/Mam, It is being my pleasure to introduce you to me. I have taken a look at your project description and I am confident that we can work together. I am expert in advance excel. I know lots for formulas. I ca Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(187 Commentaires)
7.0
Ibrahim185

Hi, I will separate the name of the products from the CODES of the products like as your sample. I will do within 2 days. Thanks Relevant Skills and Experience data processing Proposed Milestones $120 AUD - 1263 pr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(471 Commentaires)
7.2
bouslimi1979

Hi, I ll code a macro to separate the 2 columns. It can be done in 1 day. Ready to start. Thanks Expérience et Compétences appropriées Excel/VBA coder Étapes proposées $30 AUD - m

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(207 Commentaires)
7.3
FINGERRPRINT

Hi there, I have gone through the spreadsheet and the code is not always coming in front of the product, We can get code and product name separating accurately. Relevant Skills and Experience You are our high priory a Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(179 Commentaires)
7.4
P0L

Hello, I’m an Excel expert and I can do this right away! Stay tuned, I'm still working on this proposal.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(253 Commentaires)
7.0
pandey2008

Hello Sir, we have 8 member team and we can start work right now just give us one chance we will do our best,awaiting ur answer.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(259 Commentaires)
6.8
%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(190 Commentaires)
6.7
motiur03

Dear Hiring Manager, You may see my profile here: https://www.freelancer.com/u/motiur03.html Relevant Skills and Experience Gumtree, Craiglist Advert posting, web search, web scrapping, Amazon, eBay, Shopify, Wo Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(142 Commentaires)
6.9
Motiurlaw

Hi, I will separate your 1263 products name into columns as per your description. I will do it before your timeline. I am waiting for your response to start working. Thanks Relevant Skills and Experience Excel Propos Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(108 Commentaires)
6.6
sohandas

very easy project but after splitting with excel split function we need to check accuracy for 1263 rows which i will do manually so now error...pm please Relevant Skills and Experience check my recent works Proposed Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(148 Commentaires)
6.5
sujonmax2

Dear sir, Greeting. I've extensive experience ready to start work now. I'll do the work will be absolutely perfect and sound which can able to make you 100% satisfactory and it will be a great result of my work. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(109 Commentaires)
6.2
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Nex Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 0 jours
(143 Commentaires)
6.3
fatimatuzzohura

Hi, I am a highly trained on Data Entry ,Data Analysis, Data Mining, Research, Web search, scraping, Product Add, Any Type Of Ecommerce Cart, Expert with great knowledge of Word, Excel and PDF. Relevant Skills and E Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(116 Commentaires)
6.1
bilalmaher053

hi, i can separate the name of the products from the CODES and ready to start work right now, can we discus more in PM? Stay tuned, I'm still working on this proposal.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(116 Commentaires)
5.8
imraz2016

Sir i am ready to start your task its very easy for me i hope i can help you in this project and give you good job,so please contact me,thanks Relevant Skills and Experience Excel Proposed Milestones $20 AUD - full

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(126 Commentaires)
6.0
osmemon

I can get you done this in 15 minutes. I have 7 year of experience with 100% client satisfaction history. See my profile for client reviews about me. Relevant Skills and Experience Excel VBA Proposed Milestones $18 A Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(33 Commentaires)
5.6
SarahFerns

Hello, I have read the brief and understood that the job is to separate the Codes from the Product Title for 1263 products. Will be completed and delivered by Sunday EOD. Relevant Skills and Experience Sample: Master Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(38 Commentaires)
5.1
Nitu1988

Hello sir, want to do your project eagerly. Its a easy project can do anyone quickly. Relevant Skills and Experience As i have done many excell work before and do all of my work alone so i am able to take great care o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(45 Commentaires)
5.2