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.