Hello,

I'm looking for a solution to format text in Excel to be pasted into an old "green-screen" style application. (I know...)

Here is the process I'd like (see example attached ExcelCommentExtractor.xls):

1.) User inputs free-form text into C4. The only formatting done would be the hard line breaks for bulleted texts. This is illustrated in the example.
2.) The macro splits/reformats the text into a new destination cell(s) beginning with C7 using the following parameters:
- Maximum of 70 characters per line (literally a, "alt+enter" hard line break after 70 characters). This is because the green screen does not wrap text.
- The 70 character break cannot split a word (ie, if 70 falls in the middle of a word, it will break BEFORE that word
- Each destination cell can support 13 lines of text. If 13 is reached, the next line of text should begin in the cell below. This is because the green screen can only update 13 lines of text at a time.

The user can then copy/paste into the green screen and the contents of the cell will already be formatted perfectly.

I have attached a green screen screenshot in Tab 2 of the document so you can see what this looks like.

Thank you!
Nick