Apply concatenation formula to column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
Ho campers:

An extremely basic question: I have figured out how to concatenate several
Click to expand...
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... .)
 
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".
Click to expand...


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

Vaya con Dios,
Chuck, CABGx3
 
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
 
Back
Top