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
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:29 PM
Related:
- 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
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Aug 17, 2010 at 11:29 PM
Aug 17, 2010 at 11:29 PM
Try this
=IF(LEN(Master!D13)=0,"",HYPERLINK(Master!D13))
=IF(LEN(Master!D13)=0,"",HYPERLINK(Master!D13))