Range Expression

[RobertG]

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.

 

[Luke M]

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

 

[RobertG]

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.