Sure, I can help you with that! To view hidden characters in a cell, you can follow these steps:
- Select the cell or cells that you want to view the hidden characters for.
- In the Home tab of the ribbon, click on the "Find & Select" button (it looks like a pair of binoculars).
- From the drop-down menu, select "Replace".
- In the "Find what" field, type in a single space character (just hit the spacebar once).
- In the "Replace with" field, type in the same single space character.
- Click on the "Options" button to expand the options.
- Check the box next to "Match case".
- Check the box next to "Match entire cell contents".
- Click on the "Replace All" button.
This will replace all the space characters in the selected cells with the same space character, but it will also reveal any hidden characters that may be present. You should now be able to see any hidden characters that were causing the issue with identical text not being read as identical.