Apply concatenation formula to column

Ho campers:

An extremely basic question: I have figured out how to concatenate several values from a particular row (e.g. =F2&"."&G2) to get what I need in H2. How do I then apply the same formula for the entire F and G columns to show the results of each row in it's respective M row? I assume I can do this without writing a new formula in M for each row, but I've been trying various search phrases in Excel help without success. (Good thing I at least remembered "concatenate" is what I wanted to do... .)

Hope that makes sense. Thanks for any help!

George

With your original formula in M2 or H2 (you mentioned both columns),
=F2&"."&G2,
select the cell containing the formula.
Notice the small black square in the lower right corner of the cell.
This is called the "drag handle".
If you place your cursor over this square, the fat white cursor cross will
change to a skinny black cross.
Now click and drag down to copy whatever's in the cell (formula in this
case), as far as needed.
Since your formula contains relative references (NO $ signs before the cell
addresses), as the formulas is copied, the cell references will
automatically change to accommodate for each row it's copied to.

If columns F and G are already populated with data, and you are going to use
the next column (H) for you formula, you can automatically copy your formula
down column H, as far as there's data in column G by simply double clicking
on the "drag handle".

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"George" wrote in message
...
Ho campers:

An extremely basic question: I have figured out how to concatenate several
values from a particular row (e.g. =F2&"."&G2) to get what I need in H2. How
do I then apply the same formula for the entire F and G columns to show the
results of each row in it's respective M row? I assume I can do this without
writing a new formula in M for each row, but I've been trying various search
phrases in Excel help without success. (Good thing I at least remembered
"concatenate" is what I wanted to do... .)

Hope that makes sense. Thanks for any help!

George

Hi RD..........

This is cool........

If columns F and G are already populated with data, and you are going to
use
the next column (H) for you formula, you can automatically copy your
formula
down column H, as far as there's data in column G by simply double clicking
on the "drag handle".


I learn something new every day...........Thanks........

Vaya con Dios,
Chuck, CABGx3



"Ragdyer" wrote in message
...
With your original formula in M2 or H2 (you mentioned both columns),
=F2&"."&G2,
select the cell containing the formula.
Notice the small black square in the lower right corner of the cell.
This is called the "drag handle".
If you place your cursor over this square, the fat white cursor cross will
change to a skinny black cross.
Now click and drag down to copy whatever's in the cell (formula in this
case), as far as needed.
Since your formula contains relative references (NO $ signs before the
cell
addresses), as the formulas is copied, the cell references will
automatically change to accommodate for each row it's copied to.

If columns F and G are already populated with data, and you are going to
use
the next column (H) for you formula, you can automatically copy your
formula
down column H, as far as there's data in column G by simply double
clicking
on the "drag handle".

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"George" wrote in message
...
Ho campers:

An extremely basic question: I have figured out how to concatenate
several
values from a particular row (e.g. =F2&"."&G2) to get what I need in H2.
How
do I then apply the same formula for the entire F and G columns to show
the
results of each row in it's respective M row? I assume I can do this
without
writing a new formula in M for each row, but I've been trying various
search
phrases in Excel help without success. (Good thing I at least remembered
"concatenate" is what I wanted to do... .)

Hope that makes sense. Thanks for any help!

George

And if you're looking for information on this feature in Excel's Help
files, or on the Microsoft web site, look for "fill handle"


http://office.microsoft.com/assistan... P051994981033


Ragdyer wrote:
With your original formula in M2 or H2 (you mentioned both columns),
=F2&"."&G2,
select the cell containing the formula.
Notice the small black square in the lower right corner of the cell.
This is called the "drag handle".
If you place your cursor over this square, the fat white cursor cross will
change to a skinny black cross.
Now click and drag down to copy whatever's in the cell (formula in this
case), as far as needed.
Since your formula contains relative references (NO $ signs before the cell
addresses), as the formulas is copied, the cell references will
automatically change to accommodate for each row it's copied to.

If columns F and G are already populated with data, and you are going to use
the next column (H) for you formula, you can automatically copy your formula
down column H, as far as there's data in column G by simply double clicking
on the "drag handle".



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

RD:

Hey, extremely cool & easy. Really appreciate the help and reference.

Thanks!

George

Debra:

Thanks for the reference. "Fill handle!" -- Would never have come up with that (of course, it would help to RTMS, but I don't have one... that's why these forums are so great).

Thanks again & take care!

George