Hidden Character
DOH!!!!!! Thanks!
"bj" wrote:
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)).
"Sandy" wrote:
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!
|