I am designing a 'program' in excel to help capture information on forms that are received by my employer. the idea is that the user fills in the blanks, and the pre-defined text is completed with the added data using the concatenate function. However, this information is then to be copied from excel and pasted into a program that is specific to our job. This program only allows 72 characters per line of text, and DOES NOT wrap text across lines.
So, if you are 5 spaces from the end of the line, and wish to type 'sentence' you end up with 'sente' on the first line and 'nce' on the second.
I am looking for a way for count back from the end of the line (if you are still typing at that point, i.e. last character of line is not a space) to the last 'space' that was entered, then force a carriage return, and start the process again. This has to be able to handle up to 1000 characters.
If you know of a way to do this, I would be ecstatic if you could tell me how it is done. Oh yeah, the text is all kept in a certain cell (L3 at the moment).