I chart for patients. I've created an Excel workbook that upon entering basic criteria, it will bring the user to a worksheet where that criteria was transformed into a single paragraph, in a single cell.

All I now need to do is to select that cell, and copy the text. (not the whole cell) -This way I can select the company's program and simply paste what was copied. I've used the macro recorder, and it always wants to paste the whole cell.

I know this is probably simple, but I've labored on this for days.

Thank you very much in advance.