Excel: Paste multi-line text into a cell

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. 

image

Hope it helped you. Enjoy Smile

2 responses to “Excel: Paste multi-line text into a cell

  1. 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

  2. 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!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s