View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RobertG RobertG is offline
external usenet poster
 
Posts: 5
Default 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.