Adding a number to a cell reference not to the contents.

[Pedro's PhD]

Hi everyone,

Is there a formula that allows you to add to a cell reference but not to the related cell contents?

So in cell C1 it displays "C10". In cell C2 I want it to display the reference displayed in C1 + 100, so it would display "C110".

Hope that makes sense.

Thanks in advance.... Pedro

 

[mjbeam]

=concatenate(left(c1,1),value(mid(c1,2,len(c1))+100))