BeginnerText Functions
Build a mailing address with TEXTJOIN
Combine separate address fields into one line, skipping blanks.
TEXTJOIN
6 min15 points
Split a full name with LEFT and FIND
The situation
Harbor Supply's CRM export puts full names in one column, but the email tool needs first names for personalised greetings.
A1
fx
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Full name | First name | |||
| 2 | Marcus Bell | ||||
| 3 | Dana Whitfield | ||||
| 4 | Alan Reyes | ||||
| 5 | Priya Raman | ||||
| 6 |
Functions in this exercise
Who this is for
Recommended next
Related exercises
- IntermediateText Functions
Pull the year out of an order code with MID
Extract characters from the middle of a text value.
MID
7 min25 points - BeginnerText Functions
Build a mailing address with TEXTJOIN
Combine separate address fields into one line, skipping blanks.
TEXTJOIN
6 min15 points - BeginnerText Functions
Check code length with LEN
Use LEN to validate that product codes are the right length.
LEN
3 min10 points