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.

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.

 

0 Replies