so i have tried everywhere for an answer to this hopefully someone can help.
i have a spreadsheet which uses cells to populate information to generate an email with subject and body of text.
This has been working with no issues for a while until now. I enter in appropriate information for example
cell A2 = Robert
cell B2 = Hoskins
cell C2 = reference number
cell H2 = hyperlink showing text “EMail”
This has been working great so i click on the Email hyperlink and it opens my email with the correct email address and in the subject line it says
Robert Hoskins 123456
Until now, now if i change either the firstname or lastname to more than 10 characters the email hyperlink changes to #value!. I have double checked everything and cant see the problem. I have gone back to original sheet and i can input more than 20 characters in one cell and it works fine. I make a copy of the sheet or change text anywhere (not formulas) and it reverts back to the 10 char limit. All help gratefully welcomed.
Bookmarks