Initials from two names
Join the first letter of each part rather than the whole thing.
Task:
Rota sheets show staff by their initials. In C2:C6 give each person's initials from the first name in A and the last name in B, in capitals, with no spaces.
Interactive Spreadsheet
Hints
+5 XPno-hints bonusSolve it on your own to keep the bonus. Each hint gets one step closer to the formula.
Variations of CONCAT and &
0/4The same formula in the other shapes it takes at work.
- Text Concatenation
Combine text from multiple cells using concatenation.
CoreBeginner - Join text and numbers into a label
Build a readable line out of a name and a figure.
Beginner - TEXTJOIN: join a row and skip the gaps
One address line from several columns, with no doubled commas where a part is missing.
Intermediate - Initials from two names
Join the first letter of each part rather than the whole thing.
Intermediate
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | |
|---|---|---|---|
| 1 | First | Last | Initials |
| 2 | Grace | Hopper | |
| 3 | alan | turing | |
| 4 | Ada | Lovelace | |
| 5 | katherine | Johnson | |
| 6 | Tim | berners-lee |
What this exercise teachesMay contain the answer
& can join the results of functions, not just cells. Wrapping the joined text in UPPER once is shorter than applying it to each letter, and it is what makes "alan turing" come out as AT like everyone else.