Chapter 5 Cleaning up text ・ MISSION 19
Mission 19: Get the last name from a full name
Task
In B2:B5, show the last name (the part after the space).
B2fx
A
B
1
Name
Last name
2
Emma Smith
3
Olivia Brown
4
Christina Taylor
5
Liam Jones
6
Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.
Chapter 5 ・ MISSION 19
Get the last name from a full name
In B2:B5, show the last name (the part after the space).
A
B
1
Name
Last name
2
Emma Smith
3
Olivia Brown
4
Christina Taylor
5
Liam Jones
6
A
B
1
Name
Last name
2
Emma Smith
Smith
3
Olivia Brown
Brown
4
Christina Taylor
Taylor
5
Liam Jones
Jones
6
The tutorial is On. Change this in theMission list.
Functions used in this mission
Example formula: =MID(A2,FIND(" ",A2)+1,10)
If the MID length is longer than what is left, it just stops at the end. When the length varies, use a generous number.
To practice one function at a time:Function drillExcel function list
* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.
* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).