Results 1 to 1 of 1

Hyperlink function #value error

This is a discussion on Hyperlink function #value error within the Excel Questions forums, part of the Question Forums category; Hi I understand that the HYPERLINK function only accepts upto 256 characters. Does anybody have any workarounds for this. I ...

  1. #1
    Board Regular Jammydan's Avatar
    Join Date
    Feb 2010
    Location
    Jersey, Channel Islands
    Posts
    141

    Default Hyperlink function #value error

    Hi

    I understand that the HYPERLINK function only accepts upto 256 characters. Does anybody have any workarounds for this. I have various google search strings that are often longer than 256 characters and I get #VALUE error


    =HYPERLINK("" - Google Search&" "&$D6&" "&$J$7&"&btnG=Google+Search",$B$4)

    this is the full string
    "Testing Testing 123456 Testing" Jersey Crime OR Corruption OR Allegation OR Terrorism OR "Tax Evasion" OR Sanction OR "Market Abuse" OR Litigation OR Convicted -facebook.com -twitter.com -myspace.com
    Last edited by Jammydan; Oct 10th, 2013 at 10:48 AM.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com