Excel Formulas to Extract the Substring ~ A Complete Guide!!

Excel has a set of TEXT Function that can do wonders. You can do all kinds of text slice and dice operations using these functions. One of the common tasks for people working with text data is to extract a substring in Excel. This article will provide some useful tricks t o extract the substring without using the TEXT function 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:

You can use the below formula to extract the substring in Excel.

Syntax Explanations:

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.

*A1 * – It represents the input value.

Start – It represents the starting position of the text string.

End – It specifies the ending position of the text string.

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.

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

Plus operator (+) – This symbol is used to add the values.

Example:

Refer to the below example image.

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

Then specify the starting and ending position of the text string in Column C and Column D.

Select any cell and type the above-given formula to extract the substring.

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

Conclusion:

Hope you like this article on how to extract the substring in Excel without using the TEXT function. If you have any doubts regarding this topic or any other Excel VBA-related topic, ask in the comments section below.

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

Read Also:

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!!