Excel Spreadsheet - Splitting Cells

CLOSED
Bids
37
Avg Bid (USD)
$2977
Project Budget (USD)
$250 - $750

Project Description:
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 required:
Data Entry, Data Processing, Excel, Microsoft Exchange
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 275
in 1 days
$ 275
in 1 days
Hire rajanlengde
$ 250
in 3 days
Hire vnb400sl
$ 275
in 10 days
$ 252
in 1 days
$ 275
in 3 days
$ 275
in 4 days
$ 302
in 2 days
$ 250
in 3 days
$ 275
in 3 days