First all the numbers with star symbol and last four digits need to display please help me!

[Ayyappa5678]

Hi All,

I want Phone number like below snapshot of green color highlighted, First all the numbers with star symbol and last four digits need to display, can you please help me how to do this???
Note: Numbers are of total numbers like 9,10,11,12 upto 15.
Thanks in advance

[Vijay_A_Verma · Accepted solution]

Use below formula in a custom column

= Text.PadStart(Text.End(Text.From([PhoneNumber]),4),Text.Length(Text.From([PhoneNumber])),"*")

See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "MaskedPhoneNumber", each Text.PadStart(Text.End(Text.From([PhoneNumber]),4),Text.Length(Text.From([PhoneNumber])),"*")),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"PhoneNumber"})
in
    #"Removed Columns"

[Ayyappa5678 · Accepted solution]

Thank You Soo Much a lot.

Its working and great response from @Vijay_A_Verma 

[Vijay_A_Verma · Accepted solution]

Use below formula in a custom column

= Text.PadStart(Text.End(Text.From([PhoneNumber]),4),Text.Length(Text.From([PhoneNumber])),"*")

See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "MaskedPhoneNumber", each Text.PadStart(Text.End(Text.From([PhoneNumber]),4),Text.Length(Text.From([PhoneNumber])),"*")),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"PhoneNumber"})
in
    #"Removed Columns"