Excel—Include LEN and HYPERLINK in One Cell - Stack Overflow
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"
最新文章
- 向iPhone学习:谷歌计划改进Android后台管理机制
- 甲骨文:安卓让谷歌赚了220亿
- 安卓手机丢了 PC上“谷歌”一下就能找到
- "双核"创新造就苹果辉煌
- powershell - Windows AutoPilot - Set Auto Login - Stack Overflow
- javascript - Why does the letter animation work outside a <button> but not inside it? - Stack Overflow
- docker - how to fix "communications link failure the last packet sent successfully to the server was 0 milliseconds ago
- Google Translate Widget Only Works in Chrome – Why? - Stack Overflow
- eslint - How to have 2 no-restricted-globals rules with different severity? - Stack Overflow
- Error installing pip packages due to error in launcher and wrong python version - Stack Overflow
- python - Having issues getting django-simple-captcha to work on my Contact Us page - Stack Overflow
- amazon ses - Is it possible to send a RawMessage using Apache Camel AWS SES? - Stack Overflow
- javascript - How to Retrieve Logs from %temp%OfficeAddins.log.txt and Display Them in an Excale Add-in Side Panel - Stack Overfl
- Is there a class Nethereum.Signer.Transaction? - Stack Overflow
- Deploying Angular App on Azure SWA with SCSS Issues - Stack Overflow
- next.js - Update Server Component via a Client Component - Stack Overflow
- amazon web services - Nuxt build fails on AWS Amplify: Failed to find the deploy-manifest.json file in the build output - Stack