Excel Formulas to Remove the Text by Matching ~ Quick Tricks!!

When working with text data in Excel, you may have the need to remove the text before or after a specific character or text string. Here we will guide you to remove the text by matching it 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

General Formula:

  • You can use the below formula to remove the text by matching in Excel.

=SUBSTITUTE(A1,text_to_remove,””)

Syntax Explanations:

  • SUBSTITUTE – This function can 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.
  • A1 – It represents the input value.
  • Text_to_remove – It represents criteria text.
  • 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:

Let’s consider the below example image.

  • First, we will enter the input text strings in Column B.
  • Now we are going to delete some text that matched the given formula.
  • Select any cell and type the above-given formula.
  • Finally, press the ** ENTER** key, you can get the result as shown below.

Wrap-Up:

Here we have described the formulas to remove the text by matching in Excel. Hope you like this article. 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 *!! **

Read Ahead:

29

برچسب ها:

ExcelformulaExcelformulas