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

By | 2015-07-06T16:23:21+00:00 July 6th, 2015|Computers, Excel, Microsoft|0 Comments