Hyperlinks in cells

[Twatwood]

Is there a simple way to merge

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]John Doe
[/TD]
[TD]jdoe@email.com
[/TD]
[/TR]
[TR]
[TD]Joe Bloggs
[/TD]
[TD]jbloggs@email.com
[/TD]
[/TR]
[TR]
[TD]Buck Rogers
[/TD]
[TD]brogers@email.com
[/TD]
[/TR]
</tbody>[/TABLE]


into a single column with the email hyperlink already embedded beneath the name?
I don't want to have to Ctrl+K and manually insert for each of the hundreds of users and email addresses every time

 

[Dr. Demento]

This should get you there.

=HYPERLINK(B1,A1)