How can I write a formula in Excel that makes a cell equal to the last four digits of another cell?

Question

I'm trying to make a form in Outlook. These formulas are similar to Excel. I want the subject cell to equal the last four digits of the SS number cell and another cell.

Answer

Lets assume the cell with the value is B1 and you want to extract the last 4 digits to cell c1.
On cell C1 write this formula =RIGHT( B1 ,4 )

How can I write a formula in Excel that makes a cell equal to the last four digits of another cell?

Answers (1)