Find Jobs
Hire Freelancers

Do some Excel Work

£10-20 GBP

Closed
Posted over 8 years ago

£10-20 GBP

Paid on delivery
Hello, I need to to split the information in column CK that are marked with yellow into two parts because the marked cells are over 2000 characters. So what I need to do is split the ck column codes so it could be less than 2000 characters and just copy the same row but only with the half of the codes from the original row. So basically each row where column CK is marked yellow needs to be copied below the original row and CK column must be split so it would not be more than 2000 characters in a cell and in each copied row. I hope it is possible to automate this process if it is not very clear what I mean I can always show through the teamviewer how it should be done.
Project ID: 9162344

About the project

32 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
32 freelancers are bidding on average £23 GBP for this job
User Avatar
"Dear employer, I am a highly trained Data Entry ,Research, Web search, Web scrape, Product Add Any Type Of eCommerce Cart, Expert with great knowledge of Excel and all Social Networks. Please check my profile and ask me if you have any quest?? My bid is optional and I will let you chose the price that suits you best!!! I just want to prove my skills and have a long-term employer in you!!! Ready to work right now.Jewel."
£20 GBP in 1 day
4.9 (1327 reviews)
8.9
8.9
User Avatar
Hi, I am good at excel. Looking forward to work on this project. i would like to discuss the project further on the chat.
£20 GBP in 0 day
5.0 (977 reviews)
8.1
8.1
User Avatar
Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
£20 GBP in 1 day
4.9 (428 reviews)
8.1
8.1
User Avatar
Can do it now. Is it ok it to keep first 1000 characters in column CK and remaining characters in another column?
£90 GBP in 4 days
4.9 (333 reviews)
7.8
7.8
User Avatar
A proposal has not yet been provided
£19 GBP in 1 day
4.9 (450 reviews)
7.8
7.8
User Avatar
i can split ck column data into two columns with my coding with automatic way thanks i can split ck column data into two columns with my coding with automatic way thanks i can split ck column data into two columns with my coding with automatic way thanks
£15 GBP in 1 day
4.9 (697 reviews)
7.6
7.6
User Avatar
Hello, Sir I am from vSol CORP (TEAM: 19 employees). I have checked your project requirement. If you like to have a look on some sample data then please let us know. Kindly interview us to review our competencies & hire us for best desired results. Thanks
£17 GBP in 1 day
4.8 (262 reviews)
7.7
7.7
User Avatar
Hello, I can help you split data in column CK as described in a reasonably short time. I have noticed in the Example file, however, that some cells contain more than 4,000 characters. In that case would you like to split the codes over 3 or 4 rows? I look forward to working on your project and can have it complete in under 6 hours of accepting the project. Regards.
£18 GBP in 1 day
5.0 (37 reviews)
7.2
7.2
User Avatar
Hi: Here's my understanding. You can want to create two duplicate rows for the entries where CK column is marked yellow. In the created rows, you want to split the content logically such that the first row has 2000 characters and the second row has the rest of the content. Please confirm. Please note that over 90% of my completed projects are related to Excel. Moreover, I have 100% completion rate and 5-star feedback on projects. Please connect with me to discuss more
£20 GBP in 2 days
4.9 (179 reviews)
7.1
7.1
User Avatar
A proposal has not yet been provided
£22 GBP in 3 days
4.9 (90 reviews)
6.7
6.7
User Avatar
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
£15 GBP in 0 day
4.8 (197 reviews)
7.2
7.2
User Avatar
Hello, I am Excel and VBA expert. I can complete this project (automatically by macro). Please note that I have 100% completion rate and 5-star feedback on projects.
£14 GBP in 1 day
5.0 (94 reviews)
6.1
6.1
User Avatar
I do understand what you need An I can do it for you in about 1 hour- If you want, I could to teach you about how to do this kind of work in the future, paying a little more than this bid. Hope you trust on me. Please see my profile and comments about my previous works...
£18 GBP in 0 day
4.9 (60 reviews)
6.1
6.1
User Avatar
Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I can start working on the project immediately and complete the job within an hour. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
£14 GBP in 0 day
4.9 (64 reviews)
5.7
5.7
User Avatar
I'd be happy to work on this spreadsheet for you. I will copy the column that needs to be corrected into a new sheet and use the LEFT and MID functions to specify the number of characters (2000) to extract from the cell. Then I can manually copy the affected rows and paste back in the appropriate codes which were extracted. Please let me know if you would like to discuss the project further. I'm not sure if you have a very long spreadsheet or we're only dealing with the one you attached. I can correct a couple rows and show you the result to make sure we're on the same page then complete the project with little oversight. I look forward to hearing from you!
£20 GBP in 1 day
4.9 (7 reviews)
5.2
5.2
User Avatar
I have the expertise in Excel and can do this task quickly and accurately as per specifications. Ready to start work now.
£19 GBP in 1 day
4.6 (67 reviews)
5.4
5.4
User Avatar
I am an advanced user with over 10 years of MS Office experience. As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft problem, formula(s), or task.I am looking forward to help you achieve your office goals. and I am ready to start your project
£20 GBP in 0 day
4.8 (18 reviews)
4.5
4.5
User Avatar
Hello I have done a lot of work on excel so I believe I can help you with this project. But I will need some more information on what you need because it is not very clear in your description. Don't hesitate to contact me. Thanks, Michael.
£20 GBP in 2 days
5.0 (31 reviews)
4.3
4.3
User Avatar
Hi, I understand your need. I will create a short macro that takes the line from the first comma at the back to the 2000th character in a row, copy the remaining content to the row right below. If it is OK , just award me, it will take no more than 15 minutes to completion
£14 GBP in 1 day
5.0 (22 reviews)
4.5
4.5
User Avatar
Greetings. I specialize in provide solutions for Business Administration, Data Base management, KPI design, Supply Chain Planning and Project Management for commercial and industrial companies. I am also able to develop complex and automated Excel spreadsheets and Access databases, including formulas creation, pivot tables, pivot charts and data manipulation. I guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. My work will give you the confidence to initiate a long term relationship. Thank you.
£18 GBP in 1 day
5.0 (11 reviews)
4.0
4.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
1
Payment method verified
Member since Jul 19, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.