ok I tried it in a new worksheet and it also works. The worksheet I'm using
was created from a macro executed on a text file. Is there any special way I
need to save it so these formulas will work correctly? It's quite a large
file. I've copied and pasted values only into a new one but still get the
same problems.

"Eduardo" wrote:

Hi,
I copy the formula as you posted and when copy down it works Ok incrementing
each section

"Greg L." wrote:

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.