Please Update the Formula, =INDIRECT("'"&A5&"'!"&"$A$1")

[srizki]

I am using the following formula,

=INDIRECT("'"&A5&"'!"&"$A$1")

The last part $A$1 fetch
RC 016 OPERATIONS OTHER
RC 116 OPERATIONS VACATION ACCRUAL

I want to change the formula so it omits RC from each of the RC and start from the numbers.
That means I want to REPLACE RC with Space or something like that.

Regards,

 

[Scrappy666]

=right(INDIRECT("'"&A5&"'!"&"$A$1"),len(INDIRECT("'"&A5&"'!"&"$A$1"))-3)


Give that a shot

 

[srizki]

Thanks, I will try.

Yes, that worked,

Thanks again.

 

[Andrew Poulsom]

A bit shorter:

=MID(INDIRECT("'"&A5&"'!"&"$A$1"),4,255)

 

[srizki]

Thank you Andrew, I was sure there must be something shorter than this.

Many Regards,

Sohail