I have read many of the posts here but do not find a solution for my issue.
I am importing a CSV file that is generated by my construction estimating
software. Many carriage returns and spaces in the original are converted to a
special character (a box with a question mark in it)in Excel. I need to
remove these characters and replace with a space.

If I use the Clean or Trim function I lose the formatting. Essentially I
want to keep the formatting and get rid of the special character.