copy down
Hi,
be sure that your cells are format as general not as text
"Greg L." wrote:
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.
|