Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Expression
I am currently using this formula "=H19 & I19" in a column to combine two
cells adjacent so cell J19 contains the formula for the contents of H19 & I19. So the issue is this formula is not a range so as I add new rows the formula does not replicate to the new row. How can I change the formula so that it will replicate? FYI, the values in the cells are alpha/numeric so H19 = "A" and I19 = "2", so J19 = "A2" which is the reason I could not use the standard range calculation. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Expression
Your question is unclear...
so, J19 currently displays A2. What do you want it to display when you add a new row? Are you adding a row above or below? Why does the formula need to replicate (is it simply changing, or do you need it copied to another cell)? -- Best Regards, Luke M "RobertG" wrote in message ... I am currently using this formula "=H19 & I19" in a column to combine two cells adjacent so cell J19 contains the formula for the contents of H19 & I19. So the issue is this formula is not a range so as I add new rows the formula does not replicate to the new row. How can I change the formula so that it will replicate? FYI, the values in the cells are alpha/numeric so H19 = "A" and I19 = "2", so J19 = "A2" which is the reason I could not use the standard range calculation. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range Expression
Oh sorry,
I have a series of alpha values displayed in column H and a series of numeric values in the I column. The J column "=H19 & I19" just combines them like this: H Column I column J column Row 19 A 2 A2 ("=H19 & I19") Row 20 D 3 D3 ("=H20 & I20") Row 21 B 1 B1 ("=H21 & I21") This continues for the whole spreadsheet. So my question then is if I opt to add a row between row 19 and 20 above I am wanting the calculation (column J) to be placed in the new row. This process works fine for a range calculation "=sum(B2:B9)" but does not appear to work with the calc i'm using. Hope this clarifies. "Luke M" wrote: Your question is unclear... so, J19 currently displays A2. What do you want it to display when you add a new row? Are you adding a row above or below? Why does the formula need to replicate (is it simply changing, or do you need it copied to another cell)? -- Best Regards, Luke M "RobertG" wrote in message ... I am currently using this formula "=H19 & I19" in a column to combine two cells adjacent so cell J19 contains the formula for the contents of H19 & I19. So the issue is this formula is not a range so as I add new rows the formula does not replicate to the new row. How can I change the formula so that it will replicate? FYI, the values in the cells are alpha/numeric so H19 = "A" and I19 = "2", so J19 = "A2" which is the reason I could not use the standard range calculation. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can someone help me with this regular expression? | Excel Discussion (Misc queries) | |||
value expression | Excel Worksheet Functions | |||
need help with expression | Excel Discussion (Misc queries) | |||
Expression | New Users to Excel | |||
help interpreting expression | Excel Worksheet Functions |