Replace part of value

[leneprd]

hai.. Anyone pls help me...

I have a coloum name ID, and I want ti replace part of the value with xxxx. Example :

ID

12345678

23456789

17654328

I want to change a 4 last number with xxxx. it will look like :

ID

1234XXXX

2345XXXX

1765XXXX

TQ

[ChandeepChhabra · Accepted solution]

@leneprd You can add a calculated column with the following formula 

=SUBSTITUTE(Table1[ID],RIGHT(Table1[ID],4),"XXXX")

Results will look like this 

[v-xjiin-msft · Accepted solution]

Hi @leneprd,

Also, you can try a Power Query method:

Go to Edit Queries -> Add a Custom Column

=Text.Replace(Number.ToText([ID]),Text.End(Number.ToText([ID]),4),"xxxx")

Thanks,
Xi Jin.

[leneprd]

Try this method too... Got it

TQSM

[ChandeepChhabra · Accepted solution]

@leneprd You can add a calculated column with the following formula 

=SUBSTITUTE(Table1[ID],RIGHT(Table1[ID],4),"XXXX")

Results will look like this 

[leneprd]

Got it.

TQSM