Split a name with SPLIT
Step 1 of 3
SPLIT cuts a text wherever a delimiter appears and puts each part in its own cell, to the right: =SPLIT(text, delimiter).
Click Continue when you're ready.
Already know it? Type the formula straight into B2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Name | First | Last | |||
| 2 | Ann Berg | |||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
SPLIT cuts the text in A2 wherever it finds a space and puts each part in its own cell, from B2 to the right. Ann goes in B2 and Berg in C2.
Common mistake: Swapping the arguments. The text comes first and the delimiter second.
The answer
- B2
=SPLIT(1A2,2" ")
In plain words: Split 1the name in A2 at 2the space.
=SPLIT(A2," ") splits A2 at every space and spills the parts into the cells to the right. Use "," or any other character as the delimiter. Data > Split text to columns does the same once, without a formula.
+10 points