Posted to microsoft.public.excel.misc
|
|
How do I automatically input emails if I know the protocol?
E1 formula
=left(A1,1) & C1 &"@" & D1
" wrote:
Hi Everyone,
I have a sheet with First Name, MI, and Last Name in Columns A, B, and
C and company domain in column D. I would like figure out how to
combine these into an email address in column E that reads
FirstinitialLastName@"Domain" so Mel Kiper at Microsoft.com becomes
. Ideally I would like to maybe make macros for
common email protocols as well. Any Ideas?
Regards,
Reece
|