I need to fill only empty cells in a database with a symbol.

S

SMC

I'm working with a database that requires first and last name for import. I
have all the last names but some of the first names are missing and will get
kicked out of the import. Normally, I type a . in the first name cell and
that works. However, I was hoping I could select the entire first name
column and fill only the cells that are empty with a .

That would be a big time saver as I'm currently dealing with about 1250
empty column cells.

Is that possible?
 
R

RagDyeR

Select the column containing the first names.
Hit <F5>
Click "Special"
Click "Blanks"
Then <OK>

Type in your dot (period),
Then <Ctrl> <Enter>

And you're done!
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I'm working with a database that requires first and last name for import. I
have all the last names but some of the first names are missing and will get
kicked out of the import. Normally, I type a . in the first name cell and
that works. However, I was hoping I could select the entire first name
column and fill only the cells that are empty with a .

That would be a big time saver as I'm currently dealing with about 1250
empty column cells.

Is that possible?
 
Top