=========
QUESTION
———
I have a spreadsheet full of web and/or email hyperlinks, but some do not show as hyperlinks.
How do I convert them?
=========
ANSWER
———
=HYPERLINK(“mailto:”&A1, A1)
=Hyperlink(A1)
=========
EXAMPLES
———
=========
APPLIES TO / KEY WORDS
———
Hyperlink
Auto Create Hyperlink
=========
REF
———
—
http://anySiteSupport.com
http://anySiteHosting.com