65
Excel Formulas to Remove the Text By Variable Position ~ Quickly!!
In the previous post, we have seen how to remove the text by its position in Excel. Similarly, here we will show the formulas to remove the text based on its variable position in Excel. Let’s jump into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
- Use the below formula to remove the text based on variable position in Excel.
- *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.
- FIND – In Excel, the FIND function is used to find out the one text string inside the other.
- Text – It represents the input value.
- Marker – It specifies character value.
- Plus operator (+) – This symbol is used to add the values.
- 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.
Refer to the below example image.
- Here, we will enter the input text strings in Column B.
- Now we are going to remove the text string based on the variable.
- Select any cell and type the above-given formula.
- Finally, press the ** ENTER** key, you can get the result as shown below.
This page provides some useful tricks on how to remove the text by variable position in Excel. Leave a comment or reply below to let me know what you think!
Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **
65