+ Reply to Thread
Results 1 to 3 of 3

Using CONCATENATE within Hyperlink to go to a sheet in the workbook

  1. #1
    Registered User
    Join Date
    02-12-2018
    Location
    Nuernberg
    MS-Off Ver
    2013
    Posts
    20

    Using CONCATENATE within Hyperlink to go to a sheet in the workbook

    Hello everyone

    I have a sheet with sheet names in Column B, and I created a hyperlink to go to these sheets. =HYPERLINK(CONCATENATE("#",B1,"!A1"),"Go")

    My problem problem that whenever the sheet name has a space within, the formula does not work and gives me "Reference not valid".

    It works fine if the sheet name has no spaces, but if there exists any space in the sheet name it will not work. I have attached an example sheet, does anyone have a solution to this?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Using CONCATENATE within Hyperlink to go to a sheet in the workbook

    Hi
    when sheet names include spaces you have to enclose them in single brackets
    try this

    =HYPERLINK(CONCATENATE("#","'"&B1,"'!A1"),"Go")

  3. #3
    Registered User
    Join Date
    02-12-2018
    Location
    Nuernberg
    MS-Off Ver
    2013
    Posts
    20

    Re: Using CONCATENATE within Hyperlink to go to a sheet in the workbook

    Thanks a lot Nicky! I have been struggling with this

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Hyperlink to sheet in same workbook (referring to cell with name of sheet)
    By carlito2002wgn in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-27-2019, 03:41 PM
  2. Replies: 0
    Last Post: 10-27-2015, 08:59 AM
  3. Replies: 0
    Last Post: 10-27-2015, 08:57 AM
  4. Hyperlink to a hidden sheet in a same workbook
    By david2007laurent in forum Excel General
    Replies: 0
    Last Post: 07-29-2014, 06:01 PM
  5. Replies: 2
    Last Post: 01-13-2012, 04:59 PM
  6. Hyperlink to a sheet contained on another workbook
    By jpruffle in forum Excel General
    Replies: 6
    Last Post: 04-03-2009, 04:57 AM
  7. Replies: 2
    Last Post: 10-10-2007, 09:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1