Replacing blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a couple of data files that have 2 date of birth fields. Some cells
in each are blank. What I need to do is replace DOB with insureeDOB if DOB is
empty and InsureeDOB is populated. As there are several thousand records in
each file I don't want to have to do this manually. Is there a formula that
can do this? I am using Excel 2000.

Many thanks.
Chris
 
Chris,

Select your column with DOB values (which include the blanks). Then use Edit Go To... Special
Blanks. Press the = sign, arrow over to the insureeDOB field, then press CTRL-Enter. Then you can
select the DOB column and copy paste special values.

HTH,
Bernie
MS Excel MVP
 
Many thanks Bernie. That did the trick just fine. Thanks for the prompt
response.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message needed if incorrect Date Of Birth (DOB) entered 4
Test if a date falls within a given range of dates in Excel? 6
VLOOKUP not working with data from PeopleSoft 3
Data manipulation help 18
date of birth or blank cell? 3
Formula problem 2
Isolate text immediately preceding "(" 7
How to stop index match returning data where lookup cell empty 4

Back
Top