Excel: Convert column to hyperlink
========= 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