Copy multiple paragraphs into one cell
Tip by Sara Pike from PCmag. Click for the original post.
When you paste text from another application—say, Word or Outlook, or your Web browser—into Excel, the spreadsheet breaks multiple paragraphs into multiple cells, even if that means overwriting existing data in the cells beneath the target. To force Excel to place all the copied text into one cell, just press F2 before pasting (or double-click in the cell), and all the text will remain together.
---
It's useful and I think I'd better "rec" it in case I forget the next time (I read the tip 3 days ago and I almost forgot it this afternoon when I tried to connect things from many Word files into one Excel file). Hope it helps u all as well.
When you paste text from another application—say, Word or Outlook, or your Web browser—into Excel, the spreadsheet breaks multiple paragraphs into multiple cells, even if that means overwriting existing data in the cells beneath the target. To force Excel to place all the copied text into one cell, just press F2 before pasting (or double-click in the cell), and all the text will remain together.
---
It's useful and I think I'd better "rec" it in case I forget the next time (I read the tip 3 days ago and I almost forgot it this afternoon when I tried to connect things from many Word files into one Excel file). Hope it helps u all as well.
No comments:
Post a Comment