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:

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