Hyperlink for a group of addresses without individual entries?

P

Peter R

In excel, how do you make hyperkinks for 200 email addresses without
individual entries?
 
D

Dave Peterson

You have 200 addresses in A1:A200?

If yes, then maybe
=hyperlink("mailto:" & a1)
in B1 and drag it down.
 
Top