I'm trying to figure something out but I'm stumped...
I have a line of text that is between 20 and 70 characters long. What I want to do is Trim the line so it is no longer than 35 characters, but also so that is trims ONLY from the last space. This way it does not cut off a word, only puts in a break right before it.
Also, so it will take what is left over and move it to the cell beside it, so I would now have two cells of data instead of one.
help?
