Apparently in earlier versions of Excel, there was an option "Show Control Characters" which seems to be missing from 2013. Is there a way to display hidden characters in a worksheet?
I have a spreadsheet where one of the columns has a lot of seemingly blank rows but which cannot be selected using Find & Select > Go To Special > Blanks which makes me suspect that there is at least one hidden character in these cells which is not being shown.
The ultimate goal is to make these cells truly blank so they can be selected using the select-blanks command and manipulated all at once.
Edit:
I have already looked at this thread but none of the answers were helpful in this situation.
Best Answer
It appears, from my own research, the comments on the question, and lack of answers, that it is not possible to natively show hidden characters in Excel 2013.
As Raystafarian's comment pointed out, there is an add-on which claims to do this but I was unable to test it.