formulas and email
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
|