I'm trying to remove some extra white spaces, but TRIM, CLEAN and SUBSTITUTE not working.
I used CODE( ) to identify the character as 63. I tried to use SUBSTITUTE but it didn't work.
Source text is Japanese.
Please see attached workbook for a few examples.