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?

filter on the blank cells in the column, then copy the . down

JB

"SMC" wrote:

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?

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!
================================================== ===


"SMC" wrote in message
...
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?