Forum Discussion
OrangeJuiceJones
Mar 14, 2024Copper Contributor
Excel white space characters are incorrect
Hi, I have a column with a serial number which contains a white space. I am unable to search for some of the numbers, even though I can see them. It turns out that the white space have different c...
Detlef_Lewin
Mar 14, 2024Silver Contributor
Searching for a number should not be a problem because a number has no spaces.
You should explain what you are really trying to do.
Provide a sample workbook with the intended result.
Note:
Code 65 = A
Code 78 = N
Code 80 = P
"Normal" space is code 32 and non-breaking space is code 160.