Sunday, November 27, 2011

yogi_Convert Column Of Email Addresses To Hyperlinks

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:

2 comments:

  1. How about
    =IF(ISBLANK(A2), "", HYPERLINK("mailto:"&A2, "Send Email"))

    ReplyDelete
  2. Hi Oskar:

    Oh 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

    ReplyDelete