Level 2TextPractice, 2 min
SPLIT a full name
The task
In B2, split the full name in A2 into first and last name with
SPLIT. One formula fills both B2 and C2.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | |
|---|---|---|---|
| 1 | Full name | First | Last |
| 2 | Priya Raman | ||
| 3 | Theo Marsh |