LEN, UPPER, LOWER, PROPER, CONCATENATE and & in Microsoft Excel
LEN, UPPER, LOWER, PROPER, CONCATENATE
LEN function can be used to count the length of the string.
UPPER to make a text becomes uppercase.
LOWER to make a text becomes lowercase.
PROPER to make a text becomes properly right in writing.
CONCATENATE to join text(s) in cell.
& to join text(s) as well.
See the example picture below:
