Forum Discussion

OrangeJuiceJones's avatar
OrangeJuiceJones
Copper Contributor
Mar 14, 2024

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 codes. 

The normal code is 65 but some are 160, 78, and 80. 
The format is ABC 17/20

I can find and replace them but is there an easier way to do this - ideally I would want to find any spaces in entire sheet and replace them with the correct space (ALT 65 I think). Perhaps a script ?

Thanks


excel
Excel for web
Macros and VBA
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Mar 14, 2024

    OrangeJuiceJones 

    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.

     

Resources