Excel Formulas to Extract the Word that Begins with Specific Character!!

Suppose, you may need to extract the word which begins with a specific character “=” for each cell as the below screenshot shown. How could you solve this task quickly and easily in Excel? Today I introduce you to some formulas to solve this problem in Excel. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

Use the below formula to extract the word that begins with a certain character in Excel.

=TRIM(LEFT(SUBSTITUTE(MID(text,FIND(“=”,text),LEN(text)),” “,REPT(” “,100)),100))

Syntax Explanations:

TRIM – It helps to remove the extra spaces from the text and there is no space at the start or end of the text string. Read more on the TRIM function.
LEFT -In Excel, the LEFT function will help to extract the first character (starting from the left side) or characters from the given string based on the number you specified.
MID – This function helps to extract the number (starting from the left side) or characters from the given string. Read more on the MID function.
SUBSTITUTE – This function helps to replace existing text with new text in a text string when you want to replace text based on its content, not position. Read more on the SUBSTITUTE function.
REPT – In Excel, the REPT function is used to repeat characters a given number of times.
LEN – This function helps to find the length of the text string. Read more on the LEN function.
FIND – The Excel, FIND function is used to find out the one text string inside the other.
Text – 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.

Example:

Refer to the below example image.

First, we will enter the input text strings in Column B.
Now we need to extract the text that starts with the “=” symbol.

Select any cell and type the above-given formula.

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

Wind-Up:

In this blog post, we have described the formulas to extract the word that begins with the specific character in Excel. Hope you like it. Mention your queries in the comment box below.

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