I have an Excel document that's read-only and it has almost 100K records. There's a particular column where on some rows, Name Errors exist. If you hover the mouse over the field, the popup says "unrecognized text' and in the cell, it displays "#NAME?". The underlying cell shows this as the value "=-Fail control ...". I think that having the equal sign as a prefix for the rest of the text is screwing everybody up.
When I bring this column into Qlikview, the field is blank for these suspect rows. I need to know if there's any data in that field to begin with.
then the cell will be empty or contain NULL and have therefore no "real" value. That excel showed for such a cell an error like "#NAME?" is an additionally feature like a formatting, for example showing 27.04.2016 for today() but the cell-value is 42487.