Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I lock a column in Excel once data is being exported? Sandra Excel Programming 0 April 14th 08 06:51 PM
vb project data exported to excel confused[_5_] Excel Programming 2 February 26th 08 08:45 PM
Project data exported into Excel JB Excel Programming 3 March 2nd 06 07:53 PM
Exported File truncating cell data after 255 characters Sue Rizzo Excel Discussion (Misc queries) 2 March 17th 05 08:47 PM
Access table exported to Excel does not preserve blank cells Mike Collard Excel Programming 0 July 20th 04 08:05 PM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"