Did you know that you could search for hidden characters and replace with hidden characters in excel?
Simply type: alt + [ASCII Code] To find any non-printable characters.
Here are some handy Ascii codes: 0010: Carriage return (\r) 0013: Line Feed (\n) 0011: Tab (\t)