Nice work Harlan! It worked just right with text such as ImportID-

How about if it were just a number and I would still like to have it grow by
each row (if not blank)..

Such as:

1 Lucy

3 Trina

"Harlan Grove" wrote:

"Outlook, eh?" wrote...
....
I noticed that I will need the number to be counting the cell number, for
example

ImportID-01 Joe
Kathy
ImportID-03 Sam
ImportID-04 Lewis

ImportID-06 Trish

Any ideas? Thanks again very, very much!
....

Simpler. If the topmost name were in cell M2,

=TEXT((TRIM(M2)<"")*ROWS(M$2:M2),"""ImportID-""00;;")