I couldn't find another question like this in the forums, but hopefully this is fast and easy to do.
Would anyone know:
How to write a macro that will auto-replace the text string: %newline% with a new line within a cell (preferably on-the-fly) (similar to hitting ALT-Enter within a cell).
The %newline% text string can appear in any cell in the workbook, and can also happen more than once in a cell.
Thanks very much for your help!