Invisible cell content

I copied a draw for a tennis tournament from a website. Where the “byes” were in the draw, there were empty cells on my spreadsheet. So I go to “find and select,” “go to” “special” “blanks” and hit OK. When I hit delete, the blank cells don’t go away like they usually do. I figure there is a space in the cell. I go to “find” and type ~ and hit the space bar. Excel finds some spaces, but none in the apparently empty cells. YET… if I select the apparently empty cell and hit “clear” “all”, and THEN go to “find and select,” “go to” “special” “blanks” and hit OK and delete the empty cells are deleted. There is SOMETHING in the cell but it is invisible and it is not a space. How do I get rid of whatever it is? Thanks

Thanks. Your second suggestion… Char(160), F2, F9… worked fine, but only for the cell I entered that code into. (I did highlight the entire column when doing the “search and replace” with nothing.) (By the way… I tried “clean" with the same result.) I’m going to be doing this thousands of times, so I need to be able to apply it to a large range or, preferably, incorporate it into my macro. I’ve never used “substitute” … so I’m sure I’m making some ignorant mistake. Here are the exact keystrokes I’m using: (Cells with text: A1, A3, A5, A7. Cells that are apparently empty: A2, A4, A6.)
Into B1, I enter: =substitute(A1,char(160),””)
I select B1:B10 and “fill down”
Keeping B1:B10 selected, I “copy” “paste values” over the A column.
Then I try “go to special” “formulas” ok. (No formulas found.) “Go to special” “blanks” ok doesn’t work either.
Here is the link to what I copied: http://www.atpworldtour.com/en/score...580/1969/draws

The file I attached has two tabs. One has the data as copied from atpworldtour and the other is what the sheet looks like after I apply my macro. Thanks again.

I re-wrote the macro that somehow caused the problem. No more invisible cell content.