Excel Formulas to Remove the Characters From Right Side ~ Quickly!!

Have you ever tried to delete the characters from the right side? Here we will show the formulas to remove the characters from the right side in Excel. Let’s get them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

If you want to remove the characters from the right side, you can use the below formula.

=LEFT(text,LEN(text)-n)

Syntax Explanations:

LEFT – This function helps to find out the one text string inside the other. Read more on the LEFT function.
*LEN * – This function returns the length of a given text string as the number of characters. Read more on the LEN function.
Text – It represents the input value.
N – It specifies the number of characters that you want to remove.
Minus Operator (-) – This symbol will help to subtract any two 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.

Example:

Refer to the below example image.

First, we will enter the input texts in Column B.
Here we are going to remove 5 characters from the right side.

Select any cell and type the above-given formula.

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

Wind-Up:

Hope you like this article on how to remove the characters from the right side in Excel. Let me know if you have any doubts regarding this article or any other Excel/VBA topic.

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