Hello
In cell D1, I have the following formula
=CONCATENATE(G1, A1, " ", B1, " ", C1, G2)
In cell D2, I have the following formula
=CONCATENATE(G1, A2, " ", B2, " ", C2, G2)
I am trying to fill the next 1000 cells in column D with the above forumula.
Essentially, G1 and G2 should never change in the formula, yet the reference to A, B, and C should match what row number it is.
When I highlight, the first two entries listed above and then drag the forumla down the column, the references to G also change to match the row.
How do I keep them fixed to just G1 and G2?
Thank you
2007-08-02
18:55:37
·
3 answers
·
asked by
Anonymous