Hidden Character
 

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!

Hidden Character
 

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!

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!