How to check if the fields from excel is '#N/A'?

[Anonymous]

Does anyone knows how to check if the fields in a column is '#N/A'? i have tried some methods such as:

if(not(left("ColumnName",1) = Chr(35)

if(not(SubField("ColumnName",'N',1) = Chr(35)

but nothing seems to work and i'm not sure why. It would only work if i find and replace every fields that are '#N/A' to '#NA' in the excel sheet

[petter]

I have advised someone else on the topic in this thread: Help with reading Excel #Ref

Even though the title of the thread only refers to #REF it also includes #N/A values in the suggested solution.