If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Apply concatenation formula to column
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 |
#3
|
|||
|
|||
Apply concatenation formula to column
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 |
#4
|
|||
|
|||
Apply concatenation formula to column
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 |
#5
|
|||
|
|||
Apply concatenation formula to column
RD:
Hey, extremely cool & easy. Really appreciate the help and reference. Thanks! George |
#6
|
|||
|
|||
Apply concatenation formula to column
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 |
Thread Tools | |
Display Modes | |
|
|