How to auto get and merge "First & Last" name and add "@domain.com" and lowercase the all letters?

Question

I want to auto get First And Last name from Cell to another cell and lowercase all the letters, then I want add domain name provider "@example.com", please check this image to see an example:

Sheet URL: https://docs.google.com/spreadsheets/d/1XHoxD-hNmpUOMVm_u-cz-4ESrabodsrS0fIfaN-n4js/edit

user_9199828 · Answer

Try

=LOWER(SUBSTITUTE(C2," ",""))&"@example.com"

user_11225291 · Answer

If you want an arrayformula instead that you don't need to drag down:

=ARRAYFORMULA(IF(LEN(C2:C),LOWER(SUBSTITUTE(C2:C," ",""))&"@example.com",""))

How to auto get and merge "First & Last" name and add "@domain.com" and lowercase the all letters?

2 Answers