Forum Discussion
Pasting Word table into Excel creates cells within table rows, removes hyperlinks (MS 365 for Mac)
I have a Word table that includes two or more paragraphs within some rows. When I paste the table into Excel, the table rows are delimited by black lines, but within any row that included paragraphs,...
You can do the following:
- Select the table in Word.
- Replace ^p (the code for a paragraph mark in Word) with some text that doesn't occur in the document, for example %%%%
- Copy and paste the table into Excel.
- In Excel, replace %%%% with Ctrl+J (the code for a line feed in Excel)
A hyperlink in Excel can only apply to an entire cell, not to part of the text in a cell.
Years after your post, this just helped me. Thanks for posting!
