How can I overcome the HYPERLINK Functions 255 character limit?

Copper Contributor

Hi!

 

I am trying to workout how to overcome the 255 character limit for the hyperlink function in excel. Currently I have formulated a HYPERLINK link which pre-populates information for a 3rd party form (JotForm) with values from my spreadsheet. 

 

It displays #VALUE! in the cell.

 

Does anybody have any suggestions or solutions for overcoming this issue?

 

Thanks!

0 Replies