convert column of text email addresses to hyperlinks all at once

A

Ann

If I have a column of email addresses that are not formatted as hyperlinks,
but are simply text, how do I convert the entire column to hyperlinks all at
once without doing each one individually.
 
T

Tevuna

Assuming the addresses are in column A, paste this in coumn B
=HYPERLINK(A1,"Friendly Name")
 
Top