hyperlinkmicrosoft excelmicrosoft-excel-2010
I have an excel file that contains a list of steps that I follow at work.
I want to add hyperlinks to the emails I have received & saved on the hard drive.
Every time I try to add a hyperlink to text in Excel 2010, the entire cell points to it.
Is there a way to add 2 separate hyperlinks to text within a single cell in Excel 2010?
In the above image, instead of creating 2 cells linking to the emails, I want to add the links to the text itself (& eliminate the additional columns for emails)
Note: I'm on Excel 2007, but I would be surprised if this doesn't work.
Select the cells, right click, select Format Cells.
Move to the Alignment tab, set the Horizontal value to Left (Indent) and adjust the Indent value as desired.
There should be two alignment buttons on the ribbon as well (that increase or decrease the indent), they look like this:
I only needed to extract the address from a single cell's value so I found this small function handy:
Instead of a "brute force" macro, you could also create a user-defined function that would extract and return the URL for any hyperlink at which it was pointed:
Function GetURL(rng As Range) As String
On Error Resume Next
GetURL = rng.Hyperlinks(1).Address
End Function
In this case you can place it where you want. If you want, for example, the URL from a hyperlink in A1 to be listed in cell C25, then in cell C25 you would enter the following formula:
=GetURL(A1)
http://excel.tips.net/T003281_Extracting_URLs_from_Hyperlinks.html
Best Answer
Excel 2010 only allows you to create one hyperlink per cell. A workaround is to add a Microsoft Word Object with two or more hyperlinks in it: go to Insert > Object > Microsoft Word Document