Paste Multiple Cells without wrapping
Does anyone know how to paste multiple cells from either a report or another sheet into a sheet without wrapping? Meaning if someone used a carriage return in a cell...how do I get all of the cells to paste in exactly how they were on the original sheet/report?
I had thought that the error wouldn't occur if I was pasting from sheet to sheet...so I exported the report to excel and then imported it back into a SS sheet. However, it wasn't working today.