Using a formula like:

=A1 & " " & B1

where A1 contains the first name and B1 the surname, you should be
able to copy this formula down the column to row 20000. What exactly
is the problem?

Pete

On Aug 27, 2:18*pm, Cathie
wrote:
I need to merge over 20,000 first and last names and figured out how to do
that in concatnate, but I can't copy the formula into the other 19,000 names
I need to do. *Can I do this?
--
Cathie