Eric,

Put INDIRECT() inside RIGHT() & LEFT().

=RIGHT(LEFT(INDIRECT("'" & C2 & "'!A3"),16),12)


HTH,

Conan





"Eric" wrote in message
...
There is the given code,
=RIGHT(LEFT('1'!A3,16),12)
The sheet name is given in cell C2
=INDIRECT("RIGHT(LEFT('"&C2&'!A3,16),12)")
When I try this code, it does not work.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric