I have a column that contains data values like this:
NULL
NULL
NULL
NULL
NULL
NULL
Is there a formula I could use that will check to see if the cell is empty and replace the empty cells with the value 'NULL' if empty?
Thank you.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
If you're looking for a formula, you can write an if statement that checks to see if the cell is empty. For example:
If(A1="","Null",A1)
If this is a one-time need and you don't have a user that needs to reuse the formula, Saurabh's solution is a better choice. Using a formula means you have to use another column (although you can do a copy, paste special values over the original data to replace it with the formula results and then delete the formulas).
All above solutions are great and fine but wonder 1 thing, you haven't told us why you end up with a file that have NULL and empty spaces that you want to change with NULL at the first place. Maybe there you can do something !!!
Anyway, My proposal is simple:
Sort your file/this column alphabetically and you will have all empty cells first simply type NULL and drag it all the way down till you hit the first NULL.
if you opt for this option, You have to be careful to note how your file is sorted FIRST so you can apply the sorting again to have it the way it was in the begining.
rgds/gowflow
Business Accounts
Answer for Membership
by: saurabh726Posted on 2009-11-05 at 09:24:28ID: 25751757
Select your data, Then follow these steps..
Alternatively you can do this as well.
This will do what you are looking for...
Saurabh...