Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
user BrighterLater said:
Convert column of email addresses to hyperlinks
Is there an easy way to convert a text email address in a cell to a hyperlink? I have 100 of them and do not want to have to edit each on in turn to add a hyper link function and "emailto:"
------------------------------------------------------------
following is solution to the problem:
user BrighterLater said:
Convert column of email addresses to hyperlinks
Is there an easy way to convert a text email address in a cell to a hyperlink? I have 100 of them and do not want to have to edit each on in turn to add a hyper link function and "emailto:"
------------------------------------------------------------
following is solution to the problem:
How about
ReplyDelete=IF(ISBLANK(A2), "", HYPERLINK("mailto:"&A2, "Send Email"))
Hi Oskar:
ReplyDeleteOh sure, that is a good idea -- and we can now take that to the following array formula:
=ArrayFormula(IF(ISBLANK(A2:A), "", HYPERLINK("mailto:"&A2:A, "Send Email")))
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com