No need to overcomplicate things. There are two simple ways. Use the functions below
- =LOWER( A1 & "." & B1 & "@test" )
- =LOWER( CONCAT( A1, ".", B1, "@test" ) ) if older version =LOWER( CONCATENATE( A1, ".", B1, "@test" ) )
results


Whith these you can do this simply