Apply concatenation formula to column

[George]

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

Georg

 

[Ragdyer]

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 !
---------------------------------------------------------------------------

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... .)

 

[CLR]

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

 

[Debra Dalgleish]

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/assista...ID=HP051994311033&CTT=3&Origin=HP051994981033

 

[George]

RD

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

Thanks

George

 

[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