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.