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

Suppose you may need to delete the number of characters from the text string, how can you do this in Excel? This tutorial demonstrates quick tricks to remove the first N characters from a cell or a string 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

General Formula:

If you want to remove the first letter from the text string, you can use the below formula.

=REPLACE(A1,1,N,””)

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.
A1 – It represents the input value.
N – It specifies the N number of characters that you want to remove.
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.

Here, we will enter the input names in Column B.
Now we need to remove the first character from the text string.

Select any cell and type the above-given formula.

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

Conclusion:

So yeah guys this is how you can remove the first character from the text in Excel. Please feel free to state your query or feedback for the above article.

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