| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
| How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| How do I delete hidden character in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
