Hello

I am downloading a spreadsheet and copying to my workbook but I am having
trouble with hidden characters.

My formula:
=IF(ISNA(HLOOKUP("Totals: ",$R$3:$AU$28,D4+1,0)),0,-HLOOKUP("Totals:
",$R$3:$AU$28,D4+1,0)).

The cell that contains Totals: has a trailing hidden character and sometimes
a space. How can I modify my formula?

Thanks!