Indirect to refer to sheet names with ()

[Nurzhan]

Hallo,

The workbook contains sheets with name containing parenthesis. Ex. (1), (2),...I want to refer to them using the next function but it doesn't work. It works when the parenthesis are removed. The function is: =INDIRECT(CONCATENATE(B2;"!F";B1)).

Cell B2 conains sheet names
Cell B1 contains cell number

 

[Roderick_E]

Just like sheet names with spaces, the parenthesis named sheets will require single quotes around them. Like this:
=INDIRECT(CONCATENATE("'"; B2;"'!F";B1))

 

[Nurzhan]

Thanks Roderick_E !