ExcelBanter - Copying text with more than one line

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copying text with more than one line (https://www.excelbanter.com/excel-worksheet-functions/238499-copying-text-more-than-one-line.html)

Noel

Copying text with more than one line

When I copy text that is more than one line, and then paste into Excel, it
places each line in a separate cell. I want it to place it all in one cell
the way it's copied. What do I need to do?

Jacob Skaria

Copying text with more than one line

Copy in Edit mode. (Press F2 in the desired cell and copy)

If this post helps click Yes
---------------
Jacob Skaria

"Noel" wrote:

When I copy text that is more than one line, and then paste into Excel, it
places each line in a separate cell. I want it to place it all in one cell
the way it's copied. What do I need to do?

All times are GMT +1. The time now is 02:54 AM.