Excel removing first three digits of seven digit numbers

[Travis_Gawler]

We have a column of 7 digit numbers. How do I remove the first three numbers leaving only the last four numbers?

[#2]

@Travis_Gawler 

How about using Excel Power Query?

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Extracted Last Characters" = Table.TransformColumns(Source, {{"Numbers", each Text.End(Text.From(_, ""), 4), type text}}),
#"Trimmed Text" = Table.TransformColumns(#"Extracted Last Characters",{{"Numbers", Text.Trim, type text}})
in
#"Trimmed Text"

Kind Regards

Bhavik

[#3]

@Travis_Gawler 

=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.

[#4]

Thank you

[#5]

Keen to know which solution you are using Power Query or Excel.formula. If you have large data sets use Power Query.