View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Syb Syb is offline
external usenet poster
 
Posts: 2
Default 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