Maintaining carriage returns after copy and past into Notepad type program

Hi,

I have a project that I'm undertaking, and am running into a bit of trouble finding all the solutions to my many issues. One in particular is becoming a truely large thorn in my side.
My scenario is this:

I'm attempting to create a tool to allow individuals to documents their actions for working written documents, so that a standardized format and requirements can be met by all. The program thats used to keep track of all files is text based, similar to notepad. (This CANNOT be changed)

I'm using a series of fill-in boxes and radio buttons, in combinations with several =if formulas to generate an entry "documenting" your action, so that this can be copied and pasted into our "notepad" for permanent record. All of my results in being generate in a column of cells, each corresponding to the fill-ins, however my difficult is length of results vs the allowed character line in our "notepad".
MY current thought is to use one cell, and somehow limit or auto insert a char(10) entry after a predetermined number of characters. This way the hard return is copied in the outcome and hopefully correctly interpreted by out system with a return instead of just running off.

Any help or ideas, or even a direction would be greatly be appreciate. ;-)

Wow, thank you so much, worked perfectly, great instructions, and best of all copied over exactly as intended. I'd mark it solved, just one more thing, is it possible to either, assign that module to also, highlight and copy the outcomes, or could it be tied into a separate macro to first do that then your module?

My boss's have little faith in people, and to be implemented it must be idiot proof, so I've already created a button, with a macro which highlight and copy the outcome.

It seems like this would have to be accomplished after the module runs?