Online Excel - link function: 255 char limit +wrong result

Occasional Visitor

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.



in this case, cell should not be shown as linked because in TRUE branch link() function was not used.


0 Replies