format blank cells to ""

[hamking01]

I'm trying to import an excel sheet into an Access database via ASP.net pages. I need to make sure that all blank cells within Excel are "". How can I go about doing this. I've also posted this in the VBA forum. Thanx

 

[AnotherHiggins]

What are the non-null "blank" cells that are giving you trouble?

Are there cells with single or double spaces?

If so, do a Find for " " (&/or " ") and Replace with "", making sure to check the box beside For entire cells only.

If that's not the case, please give an example of your data.

[tt]__________________________________________
My name is John, and I approved this post.[/tt]

To get the best answers fast, please read faq181-2886

 

[3143]

There is also a another way to do this easily. Just choose format, cells and then from the formats own (remember to chooso cells needed). There is input field. Write to it "" and click OK. By that way you can be sure about the content.

 

[hamking01]

Actually, I need to format null cells to " ". I tried the find and replace but can't figure how to have it search for nulls. Tried find: "", replace " ". but it keeps saying that it can't find any cells under these criteria.

 

[KenWright]

If you just want to fill the blanks with a space then you can select the entire area, do edit / Go To / Special / Blanks, then type a space and hit CTRL+ENTER to entere the data. It will populate all blank cells with it.

Regards
Ken.................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[AnotherHiggins]

hamking01,

I've read your posts in other threads. Several people have asked what it is you are trying to do. You haven't answered this question yet.

In your original post, you say you want to replace "blank" cells with "" (null cells). Now you want to replace null cells with " " (which is not an empty cell). I haven't used ASP.net, but I have imported lots of Excel files into Access. Why do you want no empty cells? Do you want the entire worksheet to have no empty cells?

If you back up and ask for advice on how to get your end results instead of trying to solve one baby step of a process at a time, chances are someone here can help you figure out how to proceed.

[tt]__________________________________________
My name is John, and I approved this post.[/tt]

To get the best answers fast, please read faq181-2886