Syb,

Try this:

=HYPERLINK("mailto:" & LEFT(A1,1) & A2 & "@gmail",LEFT(A1,1) & A2 &
"@gmail")

I don't know if capital letters will affect things. You may have to adjust
the formula to make letters all lower case.

lookup the HYPERLINK() function in help for more info.

HTH,

Conan Kelly




"Syb" wrote in message
...
Is the following scenario possible?

A1 = Smith
A2 = John

I want to take the first letter of cell A2 (J), combine it with
everything from A1 (Smith) and then add @gmail.com. I'm going through
some database stuff that is all in spreadsheets and emails are not
given.

Any thoughts would be appreciated.

Jeff