Click here to Skip to main content
16,016,777 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
In an excel sheet, I'm uploading a set of datas. Some of the columns are not having any values. How can I replace those column with null values by zero?
Posted
Comments
Manisha Tambade 12-Dec-11 8:45am    
how you are uploding data 1 by 1 cellwise or directly columnwise?

1 solution

You can use ISBLANK().
For more help, go through http://excelhints.com/2007/05/30/isna-iserror-and-isblank-formula-in-excel/[^].
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900