Asked • 03/18/19

How do I copy Word tables into Excel without splitting cells into multiple rows?

I have data in a Word table that includes line and paragraph breaks. When I copy the data into Excel, it splits each line and paragraph I want into multiple cells. How do I copy the data to Excel and keep the breaks?

1 Expert Answer

By:

Stephen M.

The first part of this worked very well, but once in Excel the replacement with ^p does exactly that, the string ^p appears and not a Line Break
Report

08/19/21

Nicki F.

I have the same comment as Stephen M. In my version of Excel (Microsoft 365), the string ^p is not converted into a line break. However, I found the answer here: https://www.exceldemy.com/convert-word-table-to-excel-spreadsheet/#6_Convert_Word_Table_to_Excel_without_Splitting_Cells Pressing Ctrl + J inserts a line break (looks like a blinking period symbol) in the "Replace with"-field.
Report

09/07/22

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.