ExcelBanter - what's there in blank cell when data is exported to excel frm db

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - what's there in blank cell when data is exported to excel frm db (https://www.excelbanter.com/excel-programming/412485-whats-there-blank-cell-when-data-exported-excel-frm-db.html)

Sudhir

what's there in blank cell when data is exported to excel frm db

After exporting some data from a database to excel, when i used ISBLANK
function on a blank cell, the result is false. What is that cell containing?

Dustin B

what's there in blank cell when data is exported to excel frm db

I am not sure what is in your cell but if you use the trim function w/ the
ISBLANK it should come back true.

"sudhir" wrote:

After exporting some data from a database to excel, when i used ISBLANK
function on a blank cell, the result is false. What is that cell containing?

All times are GMT +1. The time now is 10:39 PM.