You have chosen to sponsor your bid up to a maximum amount of .
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?