Excel: How to Extract All But First Character from Cell


You can use the following formula to extract all but the first character from a string in Excel:

=RIGHT(A2, LEN(A2)-1)

This particular formula extracts all but the first character from the string in cell A2.

For example, if cell A2 contains Mavericks then this formula will return avericks.

The following example shows how to use this formula in practice.

Example: How to Extract All But First Character in Excel

Suppose we have the following column of basketball team names in Excel:

Suppose we would like to extract all but the first character from each cell in column A.

We can type the following formula into cell B2 to do so:

=RIGHT(A2, LEN(A2)-1)

We can then click and drag this formula down to each remaining cell in column B:

Excel extract all but first character

Column B now contains all but the first character from each corresponding cell in column A.

For example:

  • The formula extracts avericks from Mavericks
  • The formula extracts purs from Spurs
  • The formula extracts ockets from Rockets

And so on.

How This Formula Works

Recall the formula that we used to extract all but the first character in cell A2:

=RIGHT(A2, LEN(A2)-1)

Note that this formula uses the RIGHT function to extract a specific number of characters from the right side of each string.

By using LEN(A2) – 1, we tell Excel to extract all characters from the right side of the string up to the length of the entire string minus one.

This allows us to extract all characters except for the first character.

Note: You can find the complete documentation for the RIGHT function in Excel here.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Extract First Letter of Each Word
Excel: How to Extract First Word from Cell
Excel: How to Insert a Character into a String

Leave a Reply

Your email address will not be published. Required fields are marked *