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