Sometimes, you may need to **extract a particular text** to get better visualization and comparison. For example, you want to extract only the **customers’ names** without the **Order ID **placed in the same cell. In this tutorial, we will show you how to extract text after the first space in **Excel**.

**Table of Contents**hide

## Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

## 3 Suitable Ways to Extract Text After First Space in Excel

In the following sections, we will demonstrate **3 **suitable ways comprised of several functions such as the **MID**, the **FIND**, the **LEN**, and the **RIGHT **functions. Additionally, we will apply a **VBA **code to do the same extraction of text. In the below image, a sample data set is provided to accomplish the task.

### 1. Merge MID Function with FIND Function to Extract Text After First Space in Excel

First of all, we will apply **The MID Function** and **The FIND Function** to extract text as we need. Firstly, know how **the FIND function** works.

**Syntax of the FIND Function:**

=FIND(** find_text**,

**, [**

*within_text***])**

*start_num***Explanation of the Arguments:**

is the*Find_text***specific character**we want to find in a**reference cell**.is the*Within_text***reference cell**where the**text character**is located.is the*Start_num***serial number**of the**specific character**. If we enter**1**it will return the**first specific character number**and if we enter**2**, it will return the**second specific character**.

**Return Value:**

**The FIND function** returns the **character number** of a specific character in a **text**.

**Step 1: Select the find_text Argument**

- As we want to find the space, we type (
**“ ”**) as our*find_text*

`=FIND(" ",)`

**Step 2: Select the within_text Argument**

**Click**on cell**B5**to**select**it as our*within_text*

`=FIND(" ",B5)`

**Step 3: Type the start_num Argument**

- As we want to
**find**the**first space**in cell**B5**, type**1**as theargument with the following formula.*start_num*

`=FIND(" ",B5,1)`

**Step 4: Find the Space Character Number**

- Press
**Enter**to see the**character number**of**space**. As the first space is in the**8**number character in cell**B5**, it will result in**8**.

**Step 5: Apply the MID Function**

**Syntax of the MID Function:**

=MID(** text**,

**,**

*start_num***)**

*num_chars***Explanation of the Arguments:**

is the*Text***reference cell**where the text character is located.is the*Start_num***first character number**from which it will return the value.is the*Num_chars***last character number.**It will return the result up to that character in the character number serial.

**Return Value:**

**The MID function** returns the cell value from ** Start_num **to

**character serial number.**

*Num_chars*- For the
argument,*text***select**cell**B5**with the following formula.

`=MID(B5,FIND(" ",B5,1)`

- For the
argument, enter the value returned from*start_num***the FIND function**from.*Step 4*

`=MID(B5,FIND(" ",B5,1)`

- Enter the
argument as*num_chars***20**with the following formula.

`=MID(B5,FIND(" ",B5,1),20)`

**Step 6: Results**

- Finally, press
**Enter**to see the result with the extracted value.

- Use the
**AutoFill**tool to apply the same formula in the required blank cells.

**Read More: ****How to Extract Text after Second Space in Excel (6 Methods)**

**Similar Readings**

**Extract Text After a Character in Excel (6 Ways)****How to Extract Text Between Two Characters in Excel (4 Methods)****Extract Text Before Character in Excel (4 Quick Ways)**

### 2. Combine RIGHT, LEN, and FIND Functions to Extract Text After First Space in Excel

In the following sections, we will combine the **3 **functions of the **RIGHT**, the **LEN**, and the **FIND function **to extract text after space. Follow the steps below to complete the task.

**Step 1: Apply the FIND Function**

- Like previously, enter
**the FIND function**with the following formula. It will return**8**as the**character number**of the**space**.

`=FIND(" ",B5,1)`

**Step 2: Insert the LEN Function**

**Syntax of the MID Function:**

=LEN(** text**)

**Explanation of the Arguments:**

is the reference text value.*Text*

**Return Value:**

**The LEN function** returns the **character number** of a specific text.

- To find the difference in character numbers from the right side, type the following formula.

`=LEN(B5)-FIND(" ",B5,1)`

- Therefore, it will return
**13**as a result.

**Step 3: Insert the RIGHT Function**

**Syntax of the RIGHT Function:**

=RIGHT(** text**,[

**])**

*num_chars***Explanation of the Arguments:**

is the reference text value.*text*is the number of a specific character from the right side.*Num_chars*

**Return Value:**

**The RIGHT function** returns the **text **for a specific character number from the **right side**.

- To select
**B5**as theargument, type the following formula.*text*

`=RIGHT(B5,LEN(B5)-FIND(" ",B5,1))`

- To select the
argument, insert the return value of*num_chars***the LEN function**fromwith the following formula.*Step 2*

`=RIGHT(B5,LEN(B5)-FIND(" ",B5,1))`

**Step 4: Results**

- Finally, press
**Enter**to see the first extracted value after space.

- Therefore, use the
**AutoFill**tool to get all the extracted values.

**Read More: ****How to Extract Text between Two Spaces in Excel (5 Methods)**

### 3. Run a VBA Code to Extract Text After First Space in Excel

In addition to the previous sections, you can accomplish the same thing with the help of the **Excel VBA**. Follow the instructions below to do the task.

**Step 1: Create a Module**

- Firstly, press
**Alt**+ F**11**to open the**VBA Macro**. **Click**on the**Insert**- Then,
**select**the**Module**

**Step 2: Write a VBA Code**

**Paste**the following**VBA**

```
Sub VBA_to_extract_text()
'Declare variable
Dim Selection_Rng As Range
Dim cell_Value As Range
'Define Selection range to get from selection
Set Selection_Rng = Application.Selection
'Apply for loop
For Each cell_Value In Selection_Rng
'Formula to extract text after space
cell_Value.Offset(0, 1).Value = Right(cell_Value, Len(cell_Value) - InStr(cell_Value, " "))
Next cell_Value
End Sub
```

**Step 3: Select the Cells**

**Select**the cells in**range**.

**Step 4: Run the Program**

- Firstly,
**click**on the**Save** - Then,
**click**on the**Play**icon or press**F5**.

**Step 5: Final Results**

- After running the program, all the values will be extracted at once as shown in the image below.

**Read More: ****How to Extract Text from a Cell in Excel (5 ways)**

## Conclusion

Finally, I hope you now understand how to extract text after the first space in **Excel**. All of these strategies should be carried out when your data is being educated and practiced. Examine the practice book and apply what you’ve learned. We are driven to continue offering programs like this because of your generous support.

If you have any questions, please do not hesitate to contact us. Please share your thoughts in the comments section below.

The **Exceldemy **staff will get back to you as soon as possible.

Stay with us and continue to learn.