Excel Formulas to Remove the Text By Position ~ Simple Tutorial!!

So far we have learned the formulas to delete text based on the matching characters in Excel. Likewise, here we are going to see the formulas to remove the text by its position in Excel. Let’s step 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 delete the characters based on its position value, you can use the below formula.

Syntax Explanations:

*REPLACE * – This function helps to replace characters specified by location in a given text string with another text string. Read more on the REPLACE function.

Text – It represents the input value.

Characters – It specifies the position 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:

Refer to the below example image.

First, we will enter the input values in Column B.

Here we need to extract the text based on its position.

Select any cell and type the above-given formula.

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

Bottom-Line:

In this chapter, you can get to know the formulas to remove the text by its position in Excel. I hope that this article is useful to you. Let me know if you have any doubts regarding this article or any other article on this site.

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 Remove the Line Breaks Between Two Text Strings!!

How to Find the Last Column of Data in Excel Office 365?

Excel Formulas to Remove the First Character ~ A Complete Tutorial!!

Excel Formulas to Remove the Leading and Trailing Spaces From Text!!