Excel: Paste multi-line text into a cell

--Anand-- Uncategorized March 24, 2014 1 Minute

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.

Solution:

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 Smile

Published by --Anand--

Being in Silicon Valley for years, I became a IT Infrastructure Geek by experience and surrounded by other Geeks everywhere. I try to help others by the solutions I found on odd occasions. View all posts by --Anand--

Published March 24, 2014

2 thoughts on “Excel: Paste multi-line text into a cell”

Kevin Collins says:

May 21, 2014 at 8:38 pm

Hi. I really enjoyed my brief visit on your site and I’ll be sure to be back for more.
Can I contact your through your email?

Please email me back.

Thanks!
Kevin
kevincollins1012 gmail.com

Reply
make your own blog says:

September 13, 2014 at 12:31 am

When I originally left a comment I seem to
have clicked the -Notify me when new comments are
added- checkbox and from now on every time a comment is
added I recieve 4 emails with the exact same comment.
Perhaps there is a way you are able to remove me from
that service? Many thanks!

Reply