How to Use a Formula for MID From Right in Excel

To extract a specific text from the right side of a cell in Excel, you can use a combination of the RIGHT, LEN, and FIND functions, rather than the MID function. Here's a step-by-step guide on how to do this:

  1. Open Excel and type some text data in column A. For example, "Product-123", "Product-456", "Product-789".
  2. Click on a blank cell where you want to display the extracted text (for example, B1).
  3. Type the following formula in the blank cell:

=RIGHT(A1, LEN(A1) - FIND("-", A1))

This formula will extract the text to the right of the hyphen ("-") in the text string.

  1. Press Enter to apply the formula. The extracted text should now appear in the cell.
  2. To apply the formula to other cells, click on the cell with the formula (B1), and move your cursor to the bottom-right corner of the cell until it turns into a plus sign (+).
  3. Click and drag the plus sign down the column to apply the formula to additional cells.


Let's say you have the following data in column A:

1 | Product-123
2 | Product-456
3 | Product-789

And you want to extract the numbers after the hyphen ("-") in each cell. You can use the following formula in cell B1:

=RIGHT(A1, LEN(A1) - FIND("-", A1))

After pressing Enter, cell B1 will display "123". To apply the formula to the other cells, follow the steps mentioned above. The result will look like this:

A            B
1 | Product-123  | 123
2 | Product-456  | 456
3 | Product-789  | 789

In this example, the formula extracts the text from the right side of the hyphen ("-") in each cell in column A and displays it in column B.

Did you find this useful?