Excel Breaking Cell Value into Multiple Rows

Question

After copying a number of rows with cells having multiple lines from email, other sources, or same Excel file and pasting into another Excel file or Excel web application, the data break into multiple rows. For example, 2 rows have a column where a cell contains 3 lines of data, the number of rows became 6 when pasted into Excel. The expected result is that, if there are 3 lines of data from the original cell of 1 row, that data should still be in a single cell and should still be 1 row; not 3 rows (please refer to screenshots). How to resolve this? Thanks in advance.

Below is the expected output which was manually done by using F2 on a single cell then cut-pasting other data to be similar to the original table; but if there are a thousand rows of these, it will be a time-consuming effort. Is there a way to copy-paste the table and the number of rows are still the same like the original table from other documents?

Answer 1

Got your problem.

You can achieve this task using two methods.
1st - Using help of google sheets

• First open a blank google sheet by typing "google sheets" on google • Paste your table into google sheets you can see the formats would be same as previous
•Now you need to copy the same from google sheet and paste this into Excel sheet.

2nd- Using help of Word

• Copy the table from source and paste this into Word
• Here you need to replace the line breaks with some unique character
• Now copy paste the table into Excel and revert back the previous reppacement which was done in word

you can find more details about 2nd method here;

https://answers.microsoft.com/en-us/office/foru...

Please reply us back if you still have any questions or mark this post as resolved with your feedback :)

Thanks,
Ali

Answer 2

Hi,

Press F2 in the cell and then paste that data.

Answer 3

Thanks; but what if I have 100 rows for example, and each row has a cell containing 3 lines of data, sentence, or other case. Is there a way to copy all rows without having to F2 and copy all 100 rows' cell one by one? The expected result is to copy the original number of 100 rows with cells containing 3 lines of data. When copying from other document and pasting into Excel, the number of rows became 300 and it just highlights the border to indicate the rows from the original document; but the number of rows in Excel should just be 100 like in the original document.

Answer 4

Hi SIR,

Thanks for reaching out. My name is Ali. I'm an Independent Advisor and a Microsoft user like you. I'll be happy to help you out today.

If you have a text string copied that you want to appear in a single cell, then select that cell and change to Edit mode, then paste your clipboard.

There are a few ways to enter Edit mode e.g. double click the cell, hit F2 key etc. It's described in detail here:

you can check more about edit mode here please.

https://support.microsoft.com/en-us/office/edit...

Please reply back to us with the screenshot if you are still facing any issues (make sure to cover any private information before uploading it here as this is a public forum)

Thanks,
Ali

Answer 5

Thanks for providing the reference. I checked it; but no information to resolve the issue. I updated the question to provide the screenshots of the original copied table that contains only 3 rows (including header); but after pasting to Excel, they became 7 rows (also including the header).