How to create an email address with a formula
Channel: Muneef
Date: 28/07/2023

One of the key skills you need to be good with Excel formulas is concatenation. Put simply, concatenation is just a fancy name for joining text together. In Excel formulas, the operator for concatenation is the ampersand (&) character.

A good example of a simple concatenation task is the creation of an email address using a first and last name. The core problem is to join together parts of a name and a domain, as seen in the worksheet below. The formula in E5, copied down, is:

=LOWER(LEFT(C5)&B5)&"@"&$E$2


Read here :  https://bit.ly/478JSD6