If you copy and paste multi-line text into a Excel cell, Excel pastes into multi-row or multi-column data. This blog tip is to show how to paste a text into a cell and preserve the tabs and paragraphs into the same cell.
1. Copy your multi-line text (Control-C)
2. On Excel, Select the cell and click on Formula bar and paste text. OR Select the cell, press F2 and paste the text.
Hope it helped you. Enjoy