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.

=IF(ISBLANK(Eloquence!D5)=TRUE,"",Eloquence!D5)
Here is my Sort code if that will help:

Range("BR4:BR51").Copy
    Range("BS4").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    ActiveWorkbook.Worksheets("Game").Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("Game").Sort.SortFields.Add Key:=Range("BS4"), _
        SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
    With ActiveWorkbook.Worksheets("Game").Sort
        .SetRange Range("BS4:BS51")
        .Header = xlGuess
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
          Range("A3").Select
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.