Results 1 to 1 of 1

Thread: Hyperlink function #value error

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

    Default Hyperlink function #value error


    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
    Last edited by Jammydan; Oct 10th, 2013 at 09: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