*31*

The **MID** function in Excel allows you to extract a specific number of characters from a string based on a starting position on the left side of the string.

However, sometimes you want to extract middle characters based on a specific starting character all the way to the end of the string.

You can use the **MID** function combined with the **LEN **function to do so:

=MID(A2, 3, LEN(A2))

This particular formula extracts every character in the string in cell **A2** starting from the 3rd character all the way to the last character in the string.

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

**Example: How to Use MID Function to End of String in Excel**

Suppose we have the following list of basketball team names:

Suppose we would like to extract the characters from each team ranging from the 3rd character to the last.

We can use the following formula to do so:

=MID(A2, 3, LEN(A2))

The following screenshot shows how to use this formula in practice:

Column B now displays the characters from each team ranging from the 3rd character to the last.

Note that the **LEN()** function in Excel is used to find the length of a string.

Thus, our formula tells excel to extract the characters in each string ranging from the 3rd character to the character that represents the entire length of the string.

**Additional Resources**

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

Excel: A Formula for MID From Right

Excel: How to Use MID Function for Variable Length Strings

Excel: A Formula for “If Not Empty”