I would like to create a formula by joining together a text string and the
value within a defined cell.

For example, if the value of 10 is in the cell a5
and I have typed the value 5 in the cell h5

rather than typing =a5
I might like to create a formula rather like this ="a"&h5 or
=value("a"&"H5") to return the value in the cell a5 ie 10

I can see a lot of uses in formula building eg when copying formulas across
columns, I might like to increase the cell address row number by 1 or a
pretdetermined number each time