Joining text with & and TEXTJOIN practice exercises
Put text from several cells together into one, with spaces or other separators between the parts, and skip the cells that are empty.
- 1Join first and last name with &In C2, join the first name in A2 and the last name in B2 with a space between them. Use the & operator.
- 2Build an email addressPremiumIn C2, build the email address first.last@northwind.com in small letters from A2 and B2. Join the parts with & and wrap the whole thing in LOWER.
- 3Join an address with TEXTJOINPremiumIn E2, join A2:D2 into one address with a comma and a space between the parts. Use TEXTJOIN and skip the empty Suite cell.
- 4Build an ID from a department and a numberPremiumBadge IDs are the first 3 letters of the department in capitals, a dash and the employee number, like MAR-1042. In C2, build the ID with LEFT, UPPER and &.