Excel—Include LEN and HYPERLINK in One Cell - Stack Overflow

时间: 2025-01-06 admin 业界

I have cells that use the "=LEN(E63)" formula. I want to add a hyperlink in that same cell that appears below it that goes to a different sheet and cell in the same workbook. Is this possible?

The file path and file name include spaces in them. I want the cell to still show character count (LEN) but also have a hyperlink going to the sheet titled "References" and to a specified cell in it.

I tried using:

=LEN(E66)&HYPERLINK("filename here with spaces.xlsx'References'!C19","Go to References > C19")

Returns "Cannot open the specified file"

=LEN(E62)&","&HYPERLINK("file:///P:\folder 1 with spaces\folder2 with spaces\filename with spaces here.xlsx#'References'!A19","Click Here")

Returns "An unexpected error has occured"