I have an Excel file of about 3000 names, addresses, zip codes, etc. This
is used for a mailer database for addressing. Most of the records have a
first and/or last name field completed. However...as the xls file is
updated...there are occasionally records with no FirstName or LastName
available....only the street address...etc.

Is there a way that I can automatically have Excel fill in a text string if
and when my xls file contains records without a first name and last name.

In other words...if both the FirstName field and the LastName field are
empty in a record (row)...can I have Excel automatically enter a text string
(say "Current Resident") into the blank FirstName field...and how do I go
about this ?

Thanks in advance...

Tim R