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

S

sudhir

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?
 
D

Dustin B

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Export to PDF 0
Cell data entering slow! 0
Word macro that can call cells out of Excel for a find and replace 0
Excel - Wich Function should I use? 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Images are pixelated when saving to PDF 0
Publisher is filling blank lines with data 2
export excel data to access table using ADO 0

Top