I received a file to process that had some extra spaces casing issues such as:

"DATE    "

I first tried TRIM, but it did not help. I did find the solution by using SUBSTITUTE(A1, CHAR(160), ""). So the character was a non-breaking space or char(160).

My question is how can I find out in Excel that the space is CHAR(160) and not have to guess?