Explanation
One of the key skills you better be good with Excel formulas isconcatenation.
Put simply, concatenation is just a fancy name for joining text together.
In Excel formulas, the primary operator for concatenation is the ampersand (&).
Normally, we would also give LEFT the number of characters to extract asnum_charsargument.
With “Tom” in cell C5, the LEFT function returns “T”.
They also use the LOWER function to force all parts of the name to lowercase characters only.
For example, =LEFT(“apple”,3) returns “app”.
LOWER Function
The Excel LOWER function converts a text string to all lowercase letters.
Numbers, punctuation, and spaces are not affected.
CONCAT Function
The Excel CONCAT function concatenates (joins) values supplied as references or constants.
