It works for me. Are you sure this is the actual formula? How are you
copying it?

Regards,
Fred

"Greg L." wrote in message
...
I'm trying to merge three columns into one (first name, middle initial,
last
name). I then want to copy the formula down but it's only incrementing the
last cell in the formula.

here's what it's doing:
=q2&" "&R2&" "&p2
=q2&" "&R2&" "&p3
=q2&" "&R2&" "&p4
=q2&" "&R2&" "&p5
=q2&" "&R2&" "&p6

How do I get it to increment each reference without doing it manually? I'd
like it to be like this:

=q2&" "&R2&" "&p2
=q3&" "&R3&" "&p3
etc.

thanks.