Decorated? READ LATER! DOWNLOAD THIS POST Equally PDF >> CLICK HERE <<

Have y'all been frustrated when pasting text that is more than than one paragraph (even if only two lines) from Discussion to Excel when information technology pastes into more than 1 cell? Wondered how to paste multiple lines into a single prison cell in Excel?

Frustrated man viewing strange Excel paste results

It doesn't matter if yous use the keyboard shortcut or the Paste icon(s), your text will split into additional cells each time the Enter fundamental was pressed in the original plan. As well, the default formatting will exist from Discussion (the source program).

Paste Multi Lines into I Cell

If I paste ii or more lines that are actually multiple paragraphs into Excel in cell C4, the second paragraph will terminate up on C5, the third in C6 and so forth because the Enter key was used as explained above.

Force All Text into Ane Cell

Fortunately, there's an app for that, and so to speak. Hither's the magic fix:

  1.  Re-create your text in Word to the Clipboard.
  2.  In Excel, double click in C4 or desired cell (activates Edit mode).
  3.  Paste using your favorite method (mine is CTRL V)

All your text (regardless of  the number of paragraphs) is now in that single cell (and row)!

Annotation that your pasted information is automatically in the Destination format to match the rest of your spreadsheet and that it will word wrap to the width of that column.

Options

Other ways of activating Edit Mode are to be in the desired cell and click in the Formula Bar or press the F2 function key in the cell for the aforementioned consequence.

Controlling Line Breaks

If you would like the line intermission(s) to be different in your unmarried cell contents:

  1.  Click where you want to finish that line.
  2.  Press Alt+Enter to move everything after that down to the adjacent line (same row).*
  3.  Excel automatically adjusts the row top.

*Accommodate the cavalcade width if needed before using the control. If y'all want Excel to take care of the line breaks, use the Word Wrap control  on the Ribbon in the Home tab | Alignment group. Information technology toggles on and off with every click.

Word Wrap icon location in Excel

Alert : Be careful how much text you try to paste into a single cell as Excel has a character limit for cells. A jail cell tin merely contain a maximum of 32,767 characters. Annihilation over that will be cutting off.

Exist sure to check out my blog for more than tips that volition go your work washed faster in Excel: https://gaylelarson.com/5-amazing-must-have-excel-tips/

Take yous had issues with pasting data from other programs and getting unexpected results in Excel? Let me know in the Comments below.

BUSY? READ After! DOWNLOAD THIS POST As PDF >> CLICK Here <<

Post navigation