Concatenate fields while removing hyphens and spaces

[ExcelNoobInFL]

Hi all!
New here and so grateful for any help you can provide. This is probably easy, but I searched for quite awhile and couldn't find an answer specific to this situation. I have first name in A1, last name in A2, and trying to concatenate first and last name and add an email domain. This works great, but I need to remove spaces or hyphens from people with two last names.
I'm currently using:
=LOWER(CONCATENATE(A2,"",B2,"@gmail.com"))
which works great, but doesn't remove spaces or hyphens.

Thanks in advance!
Jonas

 

[Fluff]

Hi & welcome to MrExcel.
How about

=LOWER(CONCATENATE(A2,"",SUBSTITUTE(SUBSTITUTE(B2,"-","")," ",""),"@gmail.com"))

 

[ExcelNoobInFL]

Hi & welcome to MrExcel.
How about

=LOWER(CONCATENATE(A2,"",SUBSTITUTE(SUBSTITUTE(B2,"-","")," ",""),"@gmail.com"))

Yay! Thank you so much. You're a lifesaver ?

 

[Fluff]

You're welcome & thanks for the feedback.