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

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:

enter image description here

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



Read more here: https://stackoverflow.com/questions/66332053/how-to-auto-get-and-merge-first-last-name-and-add-domain-com-and-lowercas

Content Attribution

This content was originally published by 7amza at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: