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: