Excel cell format change

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),"-",MID(A2,LEN(LEFT(A2,5))+1,5),"-",RIGHT(A2,MOD(LEN(A2),5))),CONCATENATE(LEFT(A2,5),"-",MID(A2,LEN(LEFT(A2,5))+1,5)))

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 searcher, admin specialist, and ecommerce website management expert with more that 3 years on Freelancer.com. My bid for this task is $140, negotiable. Please let us know of any questions or concerns you have regarding our proposal. Many great thanks for the opportunity to work with you on what I am certain will be a conspicuously successful partnership. Sincerely, Kalpana

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.

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, "Can i discuss with you more about your valued project," Please feel free to let me know if you have any questions. Thank you and looking forward to hear from you. Best Regards, To-perfection Team

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, Jennifer.

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

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

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 Processing, Data correction/fixing, Data Capturing, Data Processing ,Data Reporting, Database Development, Data Entry (Offline & Online), Web Design, Web Scraping, Web Maintenance. We also have good quality control team and we can Guarantee you the work assigned will be delivered almost 100% accuracy and in time. Our Quote: We respectively submit our quote $150 for the project we can complete the project within 3 business days from the time of project awarded. We are a team of 25 staffs who have good experience in all kinds of projects. Kindly check and award us the project to start the work immediately. We are very much interested in this project and assure you that if given us this opportunity, we will prove our efficiency, reliability, IN TIME WORK DELIVERY and 100% accuracy. Thank you so much for your time to review our proposal and we look forward to working with you on this project! “Our Goal is to Keep our Customer at complete satisfaction and maintain a long-term relationship” With Warm Regards Vivek Anand K.V V2 Digital Media.

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I intend to complete this using VBA. I have more than 10 years of experience to my credit. I have also worked on advanced VB features like making of ActiveX Exe, ActiveX dlls, OCX, Win32 API, multi-threading etc.. I fully understand on this highly competetive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder

A proposal has not yet been provided

A proposal has not yet been provided

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

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.

Hi, This can be solved using formula: =MID(A2,1,5)&IF(LEN(A2)>5,"-"&MID(A2,6,5),"")&IF(LEN(A2)>10,"-"&MID(A2,11,5),"") Please send me a message so I can help you with this. Regards, Susanto

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

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

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

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

Good day, CONSIDER IT IS DONE! I CAN PROVIDE YOU A FREE DEMO!!! I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html QUESTIONS: ARE THE SKU IN ONE SHEET? Regards.

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

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 your project with a minimum time and any types of error free work. Please take a look in my review and give me a chance to work with you ! For this time i have no pending project, so i can start your job immediately with your perfect direction! Waiting to hear from you!! Thanks, dangersystem