I'm trying to create a cell in Google Sheets such that it is the value of one cell, a carriage return, and then the value of another cell. I want to be able to copy the resulting cell such that it can be pasted into a proprietary program that is expecting two cells vertically.
I'm able to create the cell using
=B3 & char(10) & B4
Which displays the values one on top of the other in the resulting cell.
The problem I have is that when I copy the contents of the new cell and paste it into my proprietary application, the carriage return doesn't copy, which was the whole point of making the cell to begin with.
Any ideas what I might do or perhaps there's a workaround I haven't thought of? It looks like there used to a web clipboard feature in Sheets but it's been discontinued.