Hi there,
I have been reading some posts about using a URL as hyperlink in excel that is longer that 255 characters.
I could not quite get the =HYPERLINK(A1&A2,"Click here") to work. I do not know where to split the URL. As soon as I populate A2, it errors.
I also found some macros which works but when I change the Display Name (which is something I have to do because the URL is part of the text in the cell) it fails.
Is there a trick or a macro that can be applied to the Workbook and allow changing the Display Name?
Than you.
I have been reading some posts about using a URL as hyperlink in excel that is longer that 255 characters.
I could not quite get the =HYPERLINK(A1&A2,"Click here") to work. I do not know where to split the URL. As soon as I populate A2, it errors.
I also found some macros which works but when I change the Display Name (which is something I have to do because the URL is part of the text in the cell) it fails.
Is there a trick or a macro that can be applied to the Workbook and allow changing the Display Name?
Than you.