Excel formula to copy over hyperlink?

Closed

k-rock - Aug 13, 2010 at 11:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:29 PM

Hello,

I've been working at this for awhile trying to find a formula that would allow me to do this:

I have this formula :
=IF(LEN(Master!D13)=0,"",Master!D13)

It's pulling over whatever is in cell D13 on the Master tab to a cell on another tab.
The cell in D13 on the Master however has a hyperlink.
I would like for the hyperlink to pull over as well, so that I can click on it and it will take me to my document.

Do you by chance know if there is something I could add to the formula to pull the hyperlink over too?

Excel formula to copy over hyperlink?
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Logitech formula vibration feedback wheel driver - Download - Drivers
Transfer data from one excel worksheet to another automatically formula - Guide

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 17, 2010 at 11:29 PM

Try this

=IF(LEN(Master!D13)=0,"",HYPERLINK(Master!D13))

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!