Avatar of agwalsh
agwalsh
 asked on

Hyperlink formula returning #Value! error

hyperlink formula not working.xlsxI have a file with a hyperlink formula. This formula works fine on another sheet (just sending you a sample) but it keeps returning a Value error. I have tried removing spaces from the email addresses, formatting it as text and I still keep getting the Value message... help appreciated! Yes, uploading the file would have definitely helped... :-=(

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rainer Jeschor

8/22/2022 - Mon
Rainer Jeschor

Hi,

could you please attach a sample?
Thanks
Pratima

It is EXCEL that has the limit of 255 characters in a Hyperlink.
Pratima

if you have less than 255 characters  -( remove some Email Text ) it is working fine
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
Rainer Jeschor

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.