In this tutorial, you will learn how to use a formula for MID from Right in Excel.

Using a beginning location on the left side of the string, the Excel MID function enables you to extract a certain amount of characters from a string.

Once ready, we’ll get started by utilizing real-world examples to show you how to use a formula for MID from Right in Excel.

Table of Contents

## Use a Formula for MID from Right in Excel

Before we begin we will need a group of data to use a formula for MID from Right in Excel.

### Step 1

First, you need to have a clean and tidy group of data to work with.

### Step 2

We can easily extract the centre values of a cell by using the MID functions. We can insert the following formula =RIGHT(REPLACE(A2,LEN(A2)-3+2,LEN(A2),””), 4).

### Step 3

Once we are done, you will be able to use a formula for MID from Right in Excel.