how to make all the Empty cells as a blank cells

[shaal]

Please find the attached excel for understanding

Lets consider only the first 3 rows on the attached excel

I am reading the excel from a java file. so that the cells F2,G2,A3,B3 and E3 are taken as empty by which it is returning as "null". But for me it should taken as "".

this can be achieved by, writing some texts in the cells F2,G2,A3,B3 and E3 and deleting the values (texts).

This can be possible for 3 or 4 rows.. But how to make it possible for the whole sheet. Any idea..??

So that none of the empty cells should return as "null" but rather it should return as "" (blank values)..

Plz help.. Its very critical and have to fix it..

[JosephP]

hi,

please see forum rule 8 on cross-posting

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

[shaal]

okie.. I understand the rule..

But the solution for this thread..??

[JosephP]

...is to obey the rules first :-)

[shaal]

What i have to do for it..??
I have to remove the same post from the other forum..?? Plz help

[JosephP]

as it says in the rule

you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

[shaal]

I have done the same..
Copied the URL and posted in the cross-post

[JosephP]

you also need to add a link here to the cross-post

[shaal]

http://www.excelforum.com/excel-gene...34#post2946334

I am new to this forum.

[Rick Rothstein]

I am new to this forum.

Just so you know, this is something you should do for any forum you cross post to... that way a volunteer on one forum will not end up wasting his/her time working up an answer for your question after it has already been answered on the other forum... without your providing the URL, they would not be able to check first before starting to work.

[shaal]

yeah.. I understand.. Thanks..

[JosephP]

the link you have provided is to this post. that is not what is required-the link we want here is to your post in the other forum.