convert column of text email addresses to hyperlinks all at once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Assuming the addresses are in column A, paste this in coumn B
=HYPERLINK(A1,"Friendly Name")
 
Back
Top