cpadilla0024
Member
Hi!
I am hitting an issue with this formula: =HYPERLINK(CONCATENATE("#",B4,"!A4"),"Click Here") because B4 as well as the tab name have a dash in the name. This formula is used to have more of a dynamic reference. Unfortunately, I cannot take out the dash because it is my organization's naming convention. Is there anything that I can plug in to fix this so the hyperlink is still functional??
I am hitting an issue with this formula: =HYPERLINK(CONCATENATE("#",B4,"!A4"),"Click Here") because B4 as well as the tab name have a dash in the name. This formula is used to have more of a dynamic reference. Unfortunately, I cannot take out the dash because it is my organization's naming convention. Is there anything that I can plug in to fix this so the hyperlink is still functional??