Questions

How can I paste multiple line content to single cell in excel

+
0 Votes
Locked

How can I paste multiple line content to single cell in excel

garymac12
When I paste multiple line content into a cell in excel it automatically divides it to multiple cells by default. I would like to have all the text together in one cell without having to retype it. Any help?
  • +
    0 Votes
    Pringles86

    Right click the cell you are going to paste to. Then select "Format Cells...", click the "Alignment" tab, check the "Word Wrap" checkbox, click ok, and paste your text.

    Let me know if this works out for you.

    +
    0 Votes
    garymac12

    Nope. It still looks at every carriage return as an opportunity to skip to the next cell.
    Word wrap allows me to type in and wraps as long as I do not hit the enter key.

    +
    0 Votes
    jennkennedy

    if you click in the cell or on the formula bar so you see the blinking cursor and then paste you will have multiple lines in one cell. it is more time consuming because you can't do many fields at once.

    +
    0 Votes
    garymac12

    Thanks, that works. This was so strange and I tried just about everything but that. Thanks again.

    +
    0 Votes
    wilecoyote22

    You paste normally but the text shows up as one huge line going off the spreadsheet. Now right click and select format cell (you could highlight multiple cells if you want). Now under format cells go to the Alignment tab. There check the "wrap text" option.

    Now your huge line of text will wrap to a single cell. Remember that you may need to adjust your cell to your liking. I suggest you adjust the width manually and just double click on the line under the row number. That will make Excel autosize the cell vertically.

    Have fun

    +
    0 Votes
    mark.ivanowski

    I have similar problem but I want to run a VBA code to Edit(F2), Paste and wrap(format).

    +
    2 Votes

    hi

    khanhVN

    double click in the cell, then paste.

    +
    0 Votes
    TobiF

    Quite old thread. (And a solution was already given higher up...)

    +
    1 Votes
    mcwong1

    We had the same problem -- pasting a chunk of text that included several paragraphs and numbered lines into a single cell -- except Excel automaticallyi distributes it into multiple cells.

    Solution: Instead of psting into the CELL, click on the cell then paste into the data-entry bar above.

    Bingo -- everything is in just that one cell.....!

    +
    0 Votes
    itpixie

    Just the job. Thanks for the short simple solution.

  • +
    0 Votes
    Pringles86

    Right click the cell you are going to paste to. Then select "Format Cells...", click the "Alignment" tab, check the "Word Wrap" checkbox, click ok, and paste your text.

    Let me know if this works out for you.

    +
    0 Votes
    garymac12

    Nope. It still looks at every carriage return as an opportunity to skip to the next cell.
    Word wrap allows me to type in and wraps as long as I do not hit the enter key.

    +
    0 Votes
    jennkennedy

    if you click in the cell or on the formula bar so you see the blinking cursor and then paste you will have multiple lines in one cell. it is more time consuming because you can't do many fields at once.

    +
    0 Votes
    garymac12

    Thanks, that works. This was so strange and I tried just about everything but that. Thanks again.

    +
    0 Votes
    wilecoyote22

    You paste normally but the text shows up as one huge line going off the spreadsheet. Now right click and select format cell (you could highlight multiple cells if you want). Now under format cells go to the Alignment tab. There check the "wrap text" option.

    Now your huge line of text will wrap to a single cell. Remember that you may need to adjust your cell to your liking. I suggest you adjust the width manually and just double click on the line under the row number. That will make Excel autosize the cell vertically.

    Have fun

    +
    0 Votes
    mark.ivanowski

    I have similar problem but I want to run a VBA code to Edit(F2), Paste and wrap(format).

    +
    2 Votes

    hi

    khanhVN

    double click in the cell, then paste.

    +
    0 Votes
    TobiF

    Quite old thread. (And a solution was already given higher up...)

    +
    1 Votes
    mcwong1

    We had the same problem -- pasting a chunk of text that included several paragraphs and numbered lines into a single cell -- except Excel automaticallyi distributes it into multiple cells.

    Solution: Instead of psting into the CELL, click on the cell then paste into the data-entry bar above.

    Bingo -- everything is in just that one cell.....!

    +
    0 Votes
    itpixie

    Just the job. Thanks for the short simple solution.