Feb 03 2021 05:27 AM
Two problems with link function in online excel.
Problem 1:
Some users on the Internet, me included, needs to set a link URL lenght more than 255 chars, but in cell will appear an error as result; althought I split URL in different cells and then I concatenate for the link function, same problem.
Seems difficult have an URL lenght bigger than 255chars, but it's not.
Please don't suggest me to use VBA because I can't.
Problem 2:
If in my formula I write link function but I don't use it, wrongly the cell is shown as linked cell.
i.g.
=IF(1=1;"test";LINK("https://www.google.it";"google"))
in this case, cell should not be shown as linked because in TRUE branch link() function was not used.