=Hyperlink() "Email"

  • Thread starter Philippe L. Balmanno
  • Start date
P

Philippe L. Balmanno

Hi,

I hope this comes out you may have to expand view to see columns.

MS XP Pro
Office XP (2002)
Excel XP (2002)

If you please I need help in determining
if there is a way to turn the product of
a formula into a hyperlink for email?

For example this formula:
D8="<"&LEFT(B8,1)&C8&"NoSpamOurDomain.ext"&">"
Product:
<[email protected]>

The '=Hyperlink(formula)' doesn't work except
when I make the product a http address.

Sample Sheet:
A B C D
1 L301 Sylvia Sowadski <[email protected]>
2 L303 Philippe Balmanno <[email protected]>
3 L305 Marcie Garcia <[email protected]>
4 L306 Alex Alvarado <[email protected]>
5 L308 Stacy Workman <[email protected]>
6 L309 Michael Flores <[email protected]>
7 L310 Christopher Penman <[email protected]>
8 L312 Edward Lopez <[email protected]>

Phil,
 
P

Philippe L. Balmanno

However, it conveniently creates an email hyperlink in my news browser (not
the Excel worksheet it is in).
 
Top