I'm creating an index page for a workbook with a large number of sheets. I've got a formula which hyperlinks to any sheet, even if the name of the sheet is changed. For instance, clicking on the cell which contains the following formula will hyperlink to cell A1 of Sheet2: =HYPERLINK(CELL("address",Sheet2!A1)) [The workbook must be saved for this function to work]
Problem: The hyperlink stops working if either the target sheet name or saved file name includes one or more space characters. Can anyone see a way to modify the formula so that the hyperlink keeps working, irrespective of whether spaces are in the target sheet-name or target file-name? I've tinkered unsuccessfully with replacing spaces in the string with , but with no success.
Thanks in advance,