convert column of text email addresses to hyperlinks all at once
 

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.

convert column of text email addresses to hyperlinks all at once
 

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

"Ann" wrote:

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.