I need to formulate an email address for hundreds of employees. The email
address is the first 7 letters of the name and first letter of first name
followed by @....com

Is there a formula that will take the last name column (only up to the first
7 letters), the first letter of the first name column and add the @.....com
to the end?

Any help would be greatly appreciated!

Thanks!