#340 Pasting Multiple Paragraphs into a Single Spreadsheet Cell

If you’ve ever tried to paste text with line breaks into an Excel worksheet and wanted to pull your hair, this tip is for you. And if you’ve never needed to do this, consider this a preventative hair-pulling intervention.

When you paste text from web pages, emails, word documents containing multiple paragraphs into Excel each paragraph will go into a cell/row of it’s own.

Default

Often you want all the paragraphs to go into a single cell instead. The solution is super simple. All you need to do is put the cell into edit mode by double-clicking in the cell or pressing your F2 key. You’ll know you’re in edit mode when you see a cursor blinking in the cell. If you paste your text now, it will all go neatly into a single cell just the way you want.

Single cell

Advertisements

2 thoughts on “#340 Pasting Multiple Paragraphs into a Single Spreadsheet Cell

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