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