Remove Blank Lines That Show Up During Sorting

Is there a way to make cells with a formula in them to appear truly empty so when I sort the rows with these "supposedly" empty cells, they don't show up in my Sort as a bunch of empty spaces before showing the actual data?

I'm thinking there is no simple formula to accomplish this, or that it may just be easier to remove these "supposedly" empty cells during the actual Sort. Though I don't know how to do that.

The issue is the "", but it's my understanding Excel has no function or easy way to make these cells with the following formula appear to be truly empty so that they aren't processed during the sorting phase.

Please Login or Register  to view this content.

Here is my Sort code if that will help:

Please Login or Register  to view this content.

So apparently, alphabetically, these "supposedly" empty cells are listed first. If I could just get them to come last, while my data is still sorted A-Z, I could possibly accept that, though I prefer they just go away.