How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Frederick S Your Own Question
Frederick S
Frederick S, Computer Specialist
Category: Microsoft Office
Satisfied Customers: 8694
Experience:  Computer technician; founder of a home PC repair company.
Type Your Microsoft Office Question Here...
Frederick S is online now
A new question is answered every 9 seconds

I want to replace blank values in a field in several hundred

This answer was rated:

I want to replace blank values in a field in several hundred records with a text value. "Find and replace" won't let me use blank data as the "find" value. Is there another way to accomplish this?
Hi there

Happy to help

What version of Excel are you using? (I'm assuming this is within Excel) 2003, 2007, or 2010?

Customer: replied 5 years ago.
I'm sorry, I didn't mention that this is Access 2010.

Simply type


into the "Find What" box instead of leaving it blank, then you'll be able to replace the cells to whatever you want.

Customer: replied 5 years ago.
I tried (Null) 'Null' and "Null" but I didn't try null. Worked perfectly, thanks.

Glad it worked for you! You may rate me at this time; thank you.

Frederick S and 2 other Microsoft Office Specialists are ready to help you