I have a column of Excel data spanning 1547 rows, containing paragraph text and carriage returns in each cell. I needed to add a special character after a final carriage return at the end of each of these cells, so I copied the column into MSWord where it was easier to edit that change and clean up other issues in the text. As expected, the Excel column imported as a table, and I made my edits. I need now to bring that table back into excel and maintain the cell structure, but Excel is ignoring the MSWord table cells and breaking all the data into separate cells at each line break.

I've tried the copy, paste, with "Keep Source Formatting" checked, but that seems to have no effect.

Any help on this would be hugely appreciated.

Thanks.