Forum Discussion

Dexlee46's avatar
Dexlee46
Brass Contributor
Dec 13, 2019

Wyn Hopkins 

 

Thank you for the input! So by exceeding the total limit, is this all the text encapsulated in the link location portion for the hyperlink function? If so, how do you overcome this?

Wyn Hopkins's avatar
Wyn Hopkins
MVP
Dec 14, 2019
As a side note, be careful with the amount of conditional formatting you are applying. the file could be come super slow.
Your table finishes at row 15,155 and then you have formatting all the way down to row 1Million
  • Dexlee46's avatar
    Dexlee46
    Brass Contributor
    Dec 16, 2019

    Thank you for the advice! 

     

    Although, I'm still having trouble getting the help cells to work. If you look at the bottom of the spreadsheet for 1912038, I created two columns for the helper columns with the mail to and subject in column 1, and the cc and body for column 2. But when I copied the syntax you used to merge them, it was unsuccessful. I'm guessing the issue is still the character limit? If this is the case, the body portion is probably the issue.

     

    Can you let me know how to proceed?

    Thanks.

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Dec 16, 2019

      HI Dexlee46 

       

      Apologies, I've done some more digging into this and splitting the items doesn't help with Hyperlink there is a hard 256 character limit regardless of how you arrive at it.

       

      Doesn't appear to be a workaround without going down the path of VBA and using some external url shortner - see this post https://stackoverflow.com/questions/3893541/exceeding-max-char-limit-in-excel  no idea if it's still relevant as it's quite an old post

Resources