First.lastname formula: =A2&"."&B2&"@lmslancers.org"
password formula: =CONCATENATE(LEFT(A2,1),LEFT(B2,1),RANDBETWEEN(10000,20000),"!")