Forum Discussion
Solved
Two set of words that looks exactly the same but somehow they are different
Hi, I have one issue that I have been trying to solve for the last 3 days but could not find what is wrong. I am not sure if this is an excel bug (or the nature of excel) or if I am doing something w...
The spaces in cell A2 are non-breaking spaces (ASCII code 160).
All spaces in cell A3 are ordinary spaces (ASCII code 32).
You can do the following:
- Select one of the (non-breaking) spaces in cell A2 and copy it (Ctrl+C).
- Select the entire range.
- Press Ctrl+H to activate the Replace dialog.
- Click in the 'Find what' box and paste (Ctrl+V).
- Click in the 'Replace with' box and press the spacebar.
- Click 'Replace All'.
The spaces in cell A2 are non-breaking spaces (ASCII code 160).
All spaces in cell A3 are ordinary spaces (ASCII code 32).
You can do the following:
- Select one of the (non-breaking) spaces in cell A2 and copy it (Ctrl+C).
- Select the entire range.
- Press Ctrl+H to activate the Replace dialog.
- Click in the 'Find what' box and paste (Ctrl+V).
- Click in the 'Replace with' box and press the spacebar.
- Click 'Replace All'.
- Thank you so mcuh!! I did not know there is difference between spaces.
>Click in the 'Replace with' box and press the spacebar.
I found on my end it did not work only by pressing the spacebar. I also copied and pasted ordinary space with Ctrl+C to replace. You saved my time so much. Thank you very much..!
