Hyperlink function #value error

Thanks Thanks:  0
Likes Likes:  0
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
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    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 -facebook.com -twitter.com -myspace.com
    Last edited by Jammydan; Oct 10th, 2013 at 10:48 AM.

User Tag List

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