I have a very convoluted formula that results with a url in a cell. FOr example, https://www.website.com. What I need is for this result to automatically be saved as a clickable hyperlink that will open that url in a web browser.
Because the formula to build the url is so convoluted (but works!) I would like to have the adjacent cell create the clickable hyperlink. For example:
Cell D3 contains the url formula results "https://www.website.com"
Cell E3 needs to contain a hyperlink to the address in Cell D3, preferably with displayed text of "Link" and a hyperlink target of the contents of cell D3.
Hope this makes sense and thanks for the help!
Because the formula to build the url is so convoluted (but works!) I would like to have the adjacent cell create the clickable hyperlink. For example:
Cell D3 contains the url formula results "https://www.website.com"
Cell E3 needs to contain a hyperlink to the address in Cell D3, preferably with displayed text of "Link" and a hyperlink target of the contents of cell D3.
Hope this makes sense and thanks for the help!