I have a program that copies text from Word into Excel.

I've tried copying the text into a string and writing that into Excel;
I've tried copying the Word text into the clipboard and pasting into Excel;

Either way, the text is a mess when it comes in and I can't seem to get it
very clean. Does anyone have a function or method for doing this cleanly? Is
it even possible?

The text is not highly formatted (only some bold). Thanks much in advance
for your suggestions.