Hyperlink Formula Issue

[ChrisHamel]

This is my formula: Whereas F2= A case Type Number and name (i.e F2= Id 12345678 Chris) That is manually entered by someone in cell F2

=HYPERLINK("mailto:"&Sheet1!A1&"?"&"cc="&Sheet1!E1&"&subject="&'INV List'!F2&"&body="&'INV List'!E1&"%0d%0a"&"I have assigned "&F2&" "&"to you for review."&"%0d%0a"&"Please let me know within 48 business hours if able to Rx"&"%0d%0a"&"or send to OAH.","Send Email")

This works until F2 becomes more than 17 characters (i.e F2= ID 12345678 ChrisH) When this happens I get a #VALUE! error.

What am i doing wrong? I am using Office 365 on a work laptop.

This is driving me mad. ANY HELP would be greatly appreciated!

 

[6StringJazzer]

It is not possible to tell without seeing all of your data (Sheet1!A1, 'INV List'!F2, 'INV List'!E1) but a HYPERLINK link is limited to 255 characters in Excel. This suggests that when F2 is 17 characters your overall link has hit the limit.

If that is the case then you would need a VBA solution.