I've been using this method so much I created a macro for it, but I'm now running into a snag, and I hope someone can help me out.
Some of the cells that I convert refer to empty cells, so the conversion leaves me with a cell that LOOKS empty. Unfortunately, if using Ctl-Up or Ctl-Down to find the end of the data range, it turns out that those "empty" cells aren't so empty after all. I can only empty them by Deleting.
Since I'm trying to automate stuff with VBA, I'm looking for a way to make them truly empty, or at least recognized as blank. Any help out there please? Pretty please???