In the attached spreadsheet, we need the codes/numbers in the column titled "Cost Code", to be split into multiple columns.
The attached screenshot is color-coded to the split that we are looking for.
First Column (red - the first two digits): "01" to "48"
Second Column (green - next four digits): 4 digits after the first two
Third Column (blue): if there are any digits after the "." - leave blank if no digits after "."
Fourth Column (yellow): the letter after the number (".O", ".M", ".S", ".L", etc.)
There is a second screenshot to illustrate the text above.
The rest of the Excel Sheet should be left as-is.
Thank you very much!
19 freelance font une offre moyenne de $19 pour ce travail
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the proje Plus
Hello Sir, I am excel expert, i can Split Numbers in Cells into Multiple Columns with 100% accuracy and very quickly, i am ready to start it right away.
Hello, i can do this project easily and accurately please message me so we can discuss further and start work ASAP. I am waiting for your reply. Thanks!
Hi! I have strong experience in these fields. I Can give you 100% accuracy for this job. Hope you would love to receive my best services. Waiting for your precious reply. Kind Regards, Zakir Zapon
Hi Thank you for giving me the opportunity to bid on this project.I have an experience in such projects.I can finish project on time and within your budget.I can do it with [login to view URL] will be satisfied with the res Plus
hello! let me do it for you. Just award the project to me and I will take care of the rest. You can be assured of a quality and accurate output. Hope you will consider me, thanks.
Hello there, My name is Prateek, I am an excel expert having 7 years of experience in excel skills. I have gone through the document and screenshot shared and i can do this task with 100% confidence. PM me to discuss Plus
$ 10 ONLY !!! In 30 Minutes Only!! Sir, I have seen your attachments and understand your requirements very well, it is quite basic to me. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Gr Plus
Hi there; I would love to work for you. I have done this kind of work before. It is easy and can be done in small time. If you want to get your work done one time, please contact me so we can discuss fur Plus
Hello. My name is Muhammad Hassan. I have high level expertise in Excel. I can do the work on time and wont disappoint you. Please share other details with me so that I can start working on it.
Hi, i have read your project description and have little bit understanding as well. I am professional data entry expert and have multiple project completion experience. Waiting for your reply and waiting anxious Plus
Hi, I am Nouran . I would like to take the chance to work with you , I am Professional in Excel and Word . I have previous experience in data entry . I am super fast and hard worker Who will complete your project wit Plus
Hi, Im have previously worked in a MNC as an excel expert. trust me 8 can complete the work within the timeline.
Hi there, I'm so excited to see your project. I want you to award me this project. I want to prepare a free sample for you. Please consider me. Thanking in Anticipation!
Yes its a simple work and i can do it right now. after complete the work u can pay me. .......................
I can assure you quality job with due sincerity and commitment. If there is any further request to adjust your demand will be adhered to.
Hello, I can do that for you, I know Python (a programming language) and I can write a program that does that almost instantly and with absolute precision and accuracy. I can provide a FREE sample of the work if you co Plus