>I can't remember what I did. When I worked for a large manufacturing company, they used to print out schedules and what have you on a big plotter to hang on the walls for employees. Some of the uploading we did from our scheduler software into Excel used multi-line data formats, and I think I remember having a very similar issue. I was almost sure it was STRTRAN(data, CHR(10), SPACE(0)) (using only ASCII-13 characters) and something else that was unique, like o.formulaR1C1().
>
>If I find that code I'll let you know. I remember at the time figuring out what to do by beginning to record a macro, doing the typing manually (with Shift+Enter), stopping the macro, and then looking at the VBA it created. I don't have Microsoft's Office on this computer (only LibreOffice) or I would try it right now. :-)
After having looked more at it, I discovered that this approach is not workable for our requirement. Excel has a maximum height for a row and this causes a conflicts with many cells that includes many lines, thus where the carriage returns was an issue, and the rest is simply lost in space.