In this tutorial, you will learn how to use LEFT to extract text before space in Excel.
Based on the amount of characters you give, LEFT returns the first character or characters in a text string.
Once ready, we’ll get started by utilizing real-world examples to show you how to use LEFT to extract text before space in Excel.
Table of Contents
Use LEFT to Extract Text Before Space in Excel
Before we begin we will need a group of data to use LEFT to extract text before space in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.

Step 2
In this example, we want to extract the values from the left before the space. To do so, we can insert the following formula =LEFT(A2, FIND(” “, A2)-1).

Step 3
Once we are done, you will be able to use LEFT to extract text before space in Excel.
