Copying Table from Word into Excel: How to remove/avoid extra 'ghost' cells

Hello!

First time on this forum. Hoping someone can help me with this rather odd issue.

I've got this table I've been working on in Word that I'd like to move to Excel because it's a little unwieldy at this point with how much info is in it.

The issue is, when I select the whole table and copy-paste it into Excel, everything copies correctly, but I end up with a bunch of smaller sub-cells for some reason. And if I try to merge them to get rid of them, it starts deleting information because it will only keep the info of one cell when merging cells.

I've attached a screenshot of part of the table in word and the result after pasting into Excel. As you can see, Excel ends up with these small, empty cells within the table cells. Is there some way to avoid this?

Thank you very much for your time and help!
-Eriias

ghost cells original.pngghost cells.png

Thank you for the link. After following a few, I got a bit of headway but it's still not working quite right. I was able to replace all the line breaks on the Word end but then trying to put them back in doesn't seem to be working.

I went with "find all ^p" and replace with "^v" (^1 wasn't finding anything at all, but ^p seemed to grab them). But doing the inverse in Excel doesn't seem to do anything, it says there's nothing to find.

I also tried the other way of replacing it with just some random text, but that garbled a LOT of the contents really badly.

Originally Posted by AliGW

It would be much easier to help if you attached the Word file.

I can't seem to figure out how to just attach a file? There's a spot for attaching images, but I don't see one for other file types...I'm visually impaired so I'm sure I'm just missing it, but if you could point it out to me I'd appreciate it. I'd attach it via google drive but it says I can't add links or images until I post a few times (which is odd since it let me put images in my original post)

Originally Posted by AliGW

I am slightly concerned about the contents of your file - have you desensitised them? If not, please remove the attachment, desensitise its contents and attach again. Remember this is a public forum and anyone can access your attachment.

Thank you for your concern. To be extra sure, I've removed everything that isn't just publicly available information about the various schools. All of the numbers etc. are things gathered from various universities' websites, so it's fine if others see it.