Excel Formulas to Get the First Word of a Text ~ Useful Guide!!

Have you ever tried to find out the first word of the text string in Excel? In this chapter, we will guide you to get the first word of a text in Excel. Let’s dive into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

If you want to find the first word of the text string, you can use the below formula.

*=LEFT(A1,FIND(” “,A1)-1) *

Syntax Explanations:

FIND – In Excel, the*FIND function* helps to find out the one text string inside the other.

LEFT – This function extracts the first character (starting from the left side) or characters from the given string based on the number you specified. Read more on the LEFT function.

Minus Operator (-) – This symbol will help to subtract any two values.

A1 – It represents the input value.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

First, we will enter the input text strings in Column B.

Here we need to extract the first word.

Select any cell and type the above-given formula.

Finally, press the ** ENTER** key, you can get the result as shown below.

Closing Words:

From this guide, you can get to know the formulas to get the first word of a text in Excel. Hope you like it. If you have any questions or suggestions regarding this lesson, feel free to use the comments section below to let us know.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Excel Formulas to Extract Nth Word From a Text String ~ Simple Tips!!

Excel Formulas to Count specific word in a range ~ Easy Tutorial!!

Formulas for Extracting Substring Between Two Texts in Excel 365!!

Excel Formulas to Extract the Month Number from Name!!