combine first initial and last name into email name

[egris52788]

in column A is first and last name. I want a formula that will add first letter of first name to last name and then add the @company.com to the end in column B.
John Jones = jjones@company.com

 

[MrKowz]

Give this a go:

Excel Workbook
	A	B
1	Jane Jones	jjones@company.com
Sheet1

Excel 2003

Cell Formulas
Range	Formula
B1	=LOWER(LEFT(A1,1)&RIGHT(A1,LEN(A1)-FIND(" ",A1))&"@company.com")

 

[Scott Huish]

=LOWER(LEFT(A1)&REPLACE(A1,1,FIND(" ",A1),""))&"@company.com"