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