Forum Discussion
FSSimon
Dec 20, 2019Copper Contributor
Help! Hyperlink style went missing (cell styles)
Hi, I hope someone can help. I have been working in some spreadsheets and have been successfully converting columns of email addresses to hyperlinks using the cell style "hyperlink." I just opened a...
FSSimon
Dec 20, 2019Copper Contributor
Fortijo Thanks so much, but I have a column populated with thousands of email addresses. Would I have to do that in every one, or can I select all?
Alan_Murray
Dec 20, 2019MVP
FSSimonYou could use the HYPERLINK function in another column to generate links quickly. The formula if your first email address was in C3 would look like this;
=HYPERLINK("Mailto:"&C3,C3)