Forum Discussion
Travis_Gawler
Apr 05, 2022Copper Contributor
Excel removing first three digits of seven digit numbers
We have a column of 7 digit numbers. How do I remove the first three numbers leaving only the last four numbers?
Riny_van_Eekelen
Apr 05, 2022Platinum Contributor
=RIGHT(A1,4)
Where A1 is assumed to be the first cell in your range of 7 digit numbers. Change if needed to suit your own schedule. Copy it down as long as needed. Copy/paste values to get rid of the formula and keep the values (i.e. 4 digits) only.