Excel formula to copy over hyperlink?

Closed

k-rock - Aug 13, 2010 at 11:58 AM
rizvisa1 Posts 4479 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?
Excel date format dd.mm.yyyy - Guide
Number to words in excel formula - Guide
Transfer data from one excel worksheet to another automatically - Guide
Mark sheet grade formula in excel download - Guide
Formula bar in excel missing - Guide

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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....?

formulas for 1st and 2nd position in class

Calculation of positions in excel

Use of '@' in formulae

Similar discussions

Subscribe To Our Newsletter!