Forum Discussion
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?
4 Replies
=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.
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
- Thank you
- Keen to know which solution you are using Power Query or Excel.formula. If you have large data sets use Power Query.
