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
Bookmarks