Excel Spreadsheet - Splitting Cells

Closed

HI there,

I need a job done where I have text in a cell.

I need to split the cell into two.

However I have to split it where the second cell has to be only 40 characters long.

the second cell must have maximum 40 characters where the count comes from the right to left.

I also cannot have words split.

so the second cell may sometimes only have 35 characters in it, which is fine.

anyone out there that can help write a code?

Skills: Data Entry, Data Processing, Excel, Microsoft Exchange

See more: excel split a cell, cells, excel count, excel split, write data excel spreadsheet, excel split cell, code excel spreadsheet, write excel code, code spreadsheet, php script count left right nodes binary tree, split data entry excel, text excel spreadsheet, spreadsheet code, excel spreadsheet job, text spreadsheet, write count data processing, count words excel cell, count excel data, count characters text, excel vba cut cell left right, words split, count excel, spreadsheet help, excel data entry count, left right horizontal scroll flash

Project ID: #4439973

35 freelancers are bidding on average $3122 for this job

techism

i can do it in couple of hours. Thanks.

$275 USD in 1 day
(15 Reviews)
3.8
ExtraNet

Very easy to implement, surely your bid range is too high for this!

$275 USD in 1 day
(6 Reviews)
3.7
rajanlengde

It can be done with VBA Code, worksheet function may not help as you require to check that the word is not broken.

$250 USD in 3 days
(7 Reviews)
3.7
vnb400sl

i can develop an app to split the cells

$275 USD in 10 days
(13 Reviews)
3.4
prakashmondal

Hi, I am interested to make an application to process excel according to your requirement. Please see PM.

$252 USD in 1 day
(3 Reviews)
3.3
buyaspreadsheet

Why should you pick me? Outstanding feedback (without exception) on all Freelancer projects to date. More than 7 years experience of designing and implementing advanced Microsoft Excel and VBA based solutions and the p More

$275 USD in 3 days
(5 Reviews)
2.7
benefitworks

Hi Sir, I can complete this project to your satisfaction. Please see more details in my private message to you. Thanks karim Benefit Works

$275 USD in 4 days
(3 Reviews)
2.5
magnussoft

Hello... My rating is 5.0. My rate of completion is 100%. My prize is minimum for the project. My milestone again minimum. Hope you decide to hire me. Best Regards...

$302 USD in 2 days
(4 Reviews)
2.3
sumon355

Hello, I am interested to do this work.

$250 USD in 3 days
(8 Reviews)
2.2
Shyamlancers

I will be able to do this - Also will be able to give a macro in mins

$275 USD in 3 days
(0 Reviews)
0.0
pblanco67

I can help you quickly and efficiently. How big is the project?

$330 USD in 3 days
(0 Reviews)
0.0
banyantech

We are very much interested to do your job

$275 USD in 1 day
(0 Reviews)
0.0
razib1982

Please check my PM.

$275 USD in 0 days
(0 Reviews)
0.0
Olalan

I am new as a freelancer in this site, but I'm used in Microsoft Office (Word, Excel, Publisher, Power Point) and also in PDF, and SPSS. Give me a chance and I'll do the best I can do

$330 USD in 5 days
(0 Reviews)
0.0
karticayen

I was expert in excel and do the job with perfection.

$715 USD in 3 days
(0 Reviews)
0.0
ricosett

I can do it for you.Please select me. Thanks.

$275 USD in 0 days
(0 Reviews)
0.0
JLiemann

Hi Sumedas, In my current position with IBM I deal with complex excel sheets every day, while also handling large quantities of data. I feel that with my experience and knowledge I will be able to complete this task More

$275 USD in 5 days
(0 Reviews)
0.0
bnea1407

I have over 15 years working with excel both using formulas and vba and could do this for you very quickly.

$275 USD in 0 days
(0 Reviews)
0.0
RobinHoo1973

Dear Sir, I have solid experience and skill in handling the case as you described. And I can make it done within hours after I double confirmed your requirements and get the sample data provided by you.

$275 USD in 1 day
(0 Reviews)
0.0
SriAnil10

Please check the private message, we assure you 100% guarantee in timelines and quality.

$550 USD in 3 days
(0 Reviews)
0.0