How use Hyperlink() function with worksheet names that contain double-quotes

[ou81aswell]

How do I specify the worksheet name to the HYPERLINK() function when the worksheet name contains a double-quote? Is there a way to "escape" the double-quote somehow?

The sheet I'm having trouble with is called 4" Nails. What changes would I have to make to the following hyperlink function in order for it to work?

=HYPERLINK("[MyWorkbook.xlsx]'4" Nails'!A1","4" Nails")

Thanks.

 

[Eric W]

Try:

=HYPERLINK("[MyWorkbook.xlsx]'4"" Nails'!A1","4"" Nails")

If you have quotes within quotes, you need to double them to say that they're supposed to be within the text, and not the text terminator.

 

[ou81aswell]

Perfect. Many thanks!

 

[Eric W]

Glad to help. Thanks for the feedback.