Build value from cell content & sheet name !

N

Neil

Hi All,

Interesting query (I hope)....

I'd like to create a value in a cell that represents a concatenation of a
value in another cell and the sheet name (tab name).

Example, sheet name is 'A' and value in cell 'M15' is '1162'.
I'd like cell 'M18' to indicate a value of '1162A'.

Any ideas ??

Thanks,

Neil
 
N

Neil

Thanks Bob,

I knew the concatenation part would be simple, retrieving the sheet name is
a little more interesting.

Regards,

Neil
 
Top