How can I change 255 character limit in 'hyperlink' function?

B

Brad B.

I am trying to use the 'hyperlink' function to compose URL addresses with the
'concatenate' function, but when the finished character string exceeds 255
characters in length I get an error. The problem seems to be with the
'link_location' field in the hyperlink command and not with the 'concatenate
function'.

Is there a way to increase the character limit for the 'link_location' field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

character limit in hyperlink function 0
Using a CONCATENATE function with an IF function. 2
Can UDF return a customized hyperlink? 3
Is there a 255 character limit in pivot table cells? 1
Pls add browse button for Hyperlink function 0
Word macro that can call cells out of Excel for a find and replace 0
How to create a hyperlink to open a file with part of the name 4
vlookup character limitations 1

Top