Originally Posted by educationnest
When I copy and paste into excel, the result gives me multiple lines. I want a single line, with the exact multiple text in a single cell. How can I do this?? Nobody in the world seems to know.
Not sure if this is what you're referring to, but you can copy and paste the data as usual. Then try wrapping the line you want to format. To do that, click the cell that's overlapping the other cells on your spreadsheet. Go to the "Home" tab and "Cells" group and click 'Format" and "Format Cells." Select the "Alignment" tab in the dialog box and check "Wrap text."
If you're trying to merge separate cells however, Excel will only retain the top, left cell's data. Checking the "Merge cells" option in the same dialog box will combine those cells for you but remove data from the bottom cells. I'm quite sure you want to retain the data in all cells. If so, this option won't work.
Hopefully, I didn't totally misunderstand your question and hope this helps.