Excel cell format change

I have about 800,000 sku in this format 123450A678 i need it to be changed to 12345-0A678. "A" or any other letter can be located AT any part of the sku. Plus sku can be 12345T12Q5E2 format anD it will have to be converted to 12345-T12Q5-E2 So i need 800,000 skus converted from solid format to "-" every five symbols

Habilidades: Processamento de Dados, Processamento de dados, Excel

Veja mais: excel format cell, excel cell format, format cell, letter format, excel cell, excel change data format, excel sku, sku excel, data entry symbols, letter excel, format letter, excel letter, excel macro format cell, change format cel excel php, form labels excel change format, change format date excel macro, multiple data cell excel, repeat division multiple cell excel, paste address cell excel internet explorer, change format filedat xls format, copying cell excel using visual basic, macro move cell excel database

Acerca do Empregador:
( 2 comentários ) London, Canada

ID do Projeto: #5102349

Concedido a:


10 years experience working with Excel in multinational companies. Please find below the formula that would help you format the data accordingly with your requirements: =IF(MOD(LEN(A2),5)>0,CONCATENATE(LEFT(A2,5)," Mais

$50 USD em 1 dia
(0 Comentários)

100 freelancers are bidding on average $101 for this job


Hi YanB, Hope you are doing well. I have completed the samples, however I am unable to send you as I can send the attachment only when you initiate a private communication with me. So I will await your response, Mais

$247 USD in 6 dias
(59 Comentários)

Hi, Highly Interested. We are ready to start your project work. We will complete quickly with 100% accuracy. Just now i checked your samples and i know how to do this. Eagerly awaiting for your project approval. Thanks Mais

$210 USD in 6 dias
(206 Comentários)

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation. This is simple task and i can finish it in 2 hours.

$30 USD in 0 dias
(146 Comentários)

Dear sir, I can do this project perfectly. Ready to start and complete it within a day. Thanks and regards, Diem.

$30 USD em 1 dia
(36 Comentários)

Looking forward to working with you....Ready to start as soon as you are...Thank you for the opportunity

$30 USD in 0 dias
(67 Comentários)

Dear YanB, Thank you very much for giving us an opportunity to bid for your project. We have well-qualified and well-organized team who are good in MS Office Data management, Data control, Data conversion, Form P Mais

$157 USD in 3 dias
(69 Comentários)

Hi, I am ready to do this for you. I will make a program for you in which you can set after how many symbols to enter number or text. Then i will process all rows and output changed file for you. Thanks

$103 USD in 2 dias
(94 Comentários)

ITS DONE- please tale the file from bellow link ;-)) [url removed, login to view] Please send me the file.. so I can do all 800,000 entries Thanks Priyal

$30 USD in 0 dias
(74 Comentários)

I can change the format of 800,000 SKUs as per your requirement. I am an Excel expert. Please consider me for accurate work.

$35 USD em 1 dia
(108 Comentários)

Expert Excel user here....using advanced formula, I can do this within half an hour...Lets start off and get it done fast.......Please check sample file completed attached.............. [url removed, login to view] Mais

$34 USD em 1 dia
(107 Comentários)

Hi, Had a look at the requirement and can take on the job. Please confirm and I shall deliver within a day. Regards, Arul

$30 USD em 1 dia
(88 Comentários)

Hi there, I'm expert in Advance Excel, Formula and Function. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.

$30 USD in 0 dias
(61 Comentários)

Hi, I'm Excel expert that's why I'm sure you'll be impressed with my work. I can complete you project in less than a day and I can offer you a best price here. Thanks. Roman

$43 USD in 0 dias
(71 Comentários)

Hi, I promise quality service with quick job submission time. I am ready to start the project immediately now and we are also ready to present a sample before we start. I am an experienced and efficient web sea Mais

$140 USD in 3 dias
(44 Comentários)

Hi, I fully understood your project. Please see the sample: [url removed, login to view] I'm ready to do it and deliver the result to you within 1 hour. A Mais

$50 USD in 0 dias
(34 Comentários)

Hi! Thanks. Read all description & understand. My sample file ready for upload, waiting your reply. Honest sincere full time professional. Regards.

$230 USD in 5 dias
(43 Comentários)

Dear sir, I can do this work according to your requirements. i am able to handle this with my best care and creativity. I have done this type of data entry project previously. I assure you that i can complete you Mais

$30 USD em 1 dia
(67 Comentários)

Hi, Easy project, it may perform by VB script and I am assuring you that it will complete as per your requirement Thanks

$100 USD in 3 dias
(30 Comentários)

Hi, I am interested in this project and assure you that if given me this opportunity, I will prove my efficiency, reliability, and 100% accuracy. Thanks Sam

$30 USD in 0 dias
(68 Comentários)

Hello, I am offering you to make this conversion using Excel VBA macro. I can either send you macro so you run it at your computer, or you can send me the whole list and I will convert it for you and send back converte Mais

$30 USD em 1 dia
(34 Comentários)