Extract Last 4 Digits In Excel

Steps to extract the last 4 digits in Excel

• Step 1: Use the RIGHT function to pull characters from the end of a string.
• Step 2: In a blank cell, type the formula =RIGHT(cell, 4) and press Enter.
  (Example: =RIGHT(A1, 4))

Result: Excel returns the last 4 characters from the value in the specified cell.

Tip: This method works for text and numbers stored as text. For pure numbers, ensure the cell is not auto-formatted (e.g., scientific notation).