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'.
I can only make the observation that when I opened your sheet in my desktop version of Excel--It was view only in the link you provided, so I opted to take your work and open it in my desktop; I did NOT retype anything--then the results are the same.
- Thank you very much!! I think it automatically replaced non-breaking spaces to spaces.
