Finding Hidden Characters In Excel

less than 1 minute read

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)

Updated: