Hidden Character

[Guest]

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!

 

[Guest]

try using the wildcard *
=IF(ISNA(HLOOKUP("Totals*",$R$3:$AU$28,D4+1,0)),0,-HLOOKUP("Totals*",
$R$3:$AU$28,D4+1,0)).

 

[Guest]

DOH!!!!!! Thanks!

try using the wildcard *
=IF(ISNA(HLOOKUP("Totals*",$R$3:$AU$28,D4+1,0)),0,-HLOOKUP("Totals*",
$R$3:$AU$28,D4+1,0)).