Chapter 5 Cleaning up text ・ MISSION 18

Mission 18: Get the first name from a full name

📋 Mission list

Task

In B2:B5, show the first name (the part before the space).

B2fx

Name

First name

Emma Smith

Olivia Brown

Christina Taylor

Liam Jones

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 startsCleaning up text

Chapter 5 ・ MISSION 18

Get the first name from a full name

In B2:B5, show the first name (the part before the space).

Now

Name

First name

Emma Smith

Olivia Brown

Christina Taylor

Liam Jones

Goal

Name

First name

Emma Smith

Emma

Olivia Brown

Olivia

Christina Taylor

Christina

Liam Jones

Liam

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =LEFT(A2,FIND(" ",A2)-1)

First names have different lengths, so use FIND(" ",A2)-1 as the number of characters in LEFT. A fixed number like LEFT(A2,4) breaks for a longer name like Christina.

To practice one function at a time:Function drill Excel 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).