I have a file that I create in Excel and save as CSV. It contains thousands
of rows and each row can end in a different column, so there are many rows
that have trailing commas that need to be removed.

I open the file in Word and run a macro where it replaces ",^p" with "^p" to
remove the commas and leave a paragraph marker at the end of each line.

The macro corrects 99% of the problem; however, it leaves random rows with
trailing commas. This forces visual review of the file to find these rows
and remove the commas manually. If I try to do a find and replace after
running the macro, Word doesn't recognize a ",^p" within the file, even
though I can turn on display of non-printable characters and see the comma
followed by the paragraph marker in each of these rows.

Any ideas on why it doesn't recognize some of these rows?

I wasn't sure to post this in Excel or Word since I can't figure out where
the problem originates.

Thanks for any help!

--
Lee Kirts

This might help:
http://gregmaxey.mvps.org/Clean_Up_Text.htm