Hi,
I am encountering a strange issue with my data. i have a table in excel which is imported from access query. there are blank cell in table, when i apply function len() for the blank cell, i am getting 0. but when i am applying function 'isblank' for blankcell i am getting 'false'. even there is no space or data in cell it is showing isblank= false
When i click the cell once or click F2, cell becomes OK. i get result of isblank as true.
Any idea what is the issue and how to over come this.
Regards
Ajaar
I am encountering a strange issue with my data. i have a table in excel which is imported from access query. there are blank cell in table, when i apply function len() for the blank cell, i am getting 0. but when i am applying function 'isblank' for blankcell i am getting 'false'. even there is no space or data in cell it is showing isblank= false
When i click the cell once or click F2, cell becomes OK. i get result of isblank as true.
Any idea what is the issue and how to over come this.
Regards
Ajaar