We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
4 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Excel Hyperlink 2007
Posted on 2014-11-14
Hi experts,
I am trying to maintain documents/artifacts inventory in excel 2007 and have source and destination columns for information source and then where I am uploading in SharePoint. Instead of long links displayed I want to give some proper name ABC for example and when clicked on it should take to the website. I was able to do for some and not for many links . I think excel does not support links length more then 250 characters. I tried using tinyurl.com to shorten the link , but my co doesn't allow using it. So without diving into VBA , is there a simple solution to giving meaningful names to hyperlinks that are longer 250+ in characters in excel 2007?
Thanks in advance
excel-hyperlink-issue.xlsx
I am trying to maintain documents/artifacts inventory in excel 2007 and have source and destination columns for information source and then where I am uploading in SharePoint. Instead of long links displayed I want to give some proper name ABC for example and when clicked on it should take to the website. I was able to do for some and not for many links . I think excel does not support links length more then 250 characters. I tried using tinyurl.com to shorten the link , but my co doesn't allow using it. So without diving into VBA , is there a simple solution to giving meaningful names to hyperlinks that are longer 250+ in characters in excel 2007?
Thanks in advance
excel-hyperlink-issue.xlsx
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
2- +1
8 Comments
Please solve the above link as an example. I am a visual person and like to see if the above link can be given a name for example "ABC" and when ABC is clicked the above link should open. In the meantime, I will research using concatenate. Thanks again
Paul ,
yes like the example you just showed above but that needs to happen in excel and not like the link above.I need a solution in excel where a long hyperlink can be given a descriptive short name and when clicked on it , the link should open.
yes like the example you just showed above but that needs to happen in excel and not like the link above.I need a solution in excel where a long hyperlink can be given a descriptive short name and when clicked on it , the link should open.
Active today
I tried and tried - but for the really long links, it can't be done!
When I copy the above link using the above example and get only the first part of the link,
But you CAN copy the entire link directly to a cell and to hide it by writing something in the cell immediately to the right of the link!
When I copy the above link using the above example and get only the first part of the link,
But you CAN copy the entire link directly to a cell and to hide it by writing something in the cell immediately to the right of the link!
Active today
The limit you face is a maximum of 255 characters in your hyperlinks. You will need to talk to your IT department and get permission to use link shorteners to get around this limit--or upgrade your users to Excel 2013.
1. Paste the URL directly in a cell (i.e. not in the formula bar). It should display as a hyperlink when done correctly.
2. Format the cell using a Custom Number Format like:
;;;"GHIJ"
The three semicolons are placeholders for the formats (none specified) for positive numbers, negative numbers and 0. The text (inside doublequotes) after the third semicolon is the number format used for text. It will be displayed as the "friendly URL" for the hyperlink.
LongTextHyperlinkQ28562225.xlsx
The following is working in Excel 2013, but not 2010 or 2007!
Though somewhat laborious, you can use a Custom number format to hide the text of the really long hyperlinks. In so doing, you can display the desired short text instead of the really long hyperlink.1. Paste the URL directly in a cell (i.e. not in the formula bar). It should display as a hyperlink when done correctly.
2. Format the cell using a Custom Number Format like:
;;;"GHIJ"
The three semicolons are placeholders for the formats (none specified) for positive numbers, negative numbers and 0. The text (inside doublequotes) after the third semicolon is the number format used for text. It will be displayed as the "friendly URL" for the hyperlink.
LongTextHyperlinkQ28562225.xlsx
Featured Post
An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month4 days, 10 hours left to enroll
687 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.