Dear all
I have a question
If i have a e-mail address "[email protected]"in a1 . I want to use the function Hyperlink(A1) and it turns to hyperlink but is not an e-mail link.
How i can i make it an e-mail link?
Eric
Dear all
I have a question
If i have a e-mail address "[email protected]"in a1 . I want to use the function Hyperlink(A1) and it turns to hyperlink but is not an e-mail link.
How i can i make it an e-mail link?
Eric
Dear all
I found the answer on Youtube
=HYPERLINK("mailto:"&A1,A1)
Eric
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks