Results 1 to 2 of 2

Thread: Hyperlink function reference multiple cells?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #2
    Ok so I made a lot of progress but hit some more walls. Here's what I have so far:

    =HYPERLINK("url?subject="&SUBSTITUTE(A11," ","%20"&"&description=test......", "test")

    The substitute part allows me to remove spaces from the text in A11 so the browser will run the URL and the invite will include the spaces back in.

    Now the wall... It seems that there is some kind of maximum character limit I am hitting... If I increase the amount of text in A11, the hyperlink shows up as #value. Also if I try to do anything not<=4 characters in the description field it will also show up as #value.
    Last edited by totalnoob; 01-12-2018 at 01:53 PM.

Posting Permissions

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