Help

Re: Replacing last 4 characters with stars ***

Solved
Jump to Solution
378 0
cancel
Showing results for 
Search instead for 
Did you mean: 
chegyy
4 - Data Explorer
4 - Data Explorer

Looking for a solution for a public view where I would like to share information partly. To be exact - I'd like to hide the last characters of the text string by replacing the last letters with stars ***

Tried to look up for ready solutions but had no luck.

Would appreciate any help.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try this:

SUBSTITUTE(
  Name,
  RIGHT(
    Name,
    4
  ),
  "****"
)

Screenshot 2024-02-18 at 12.44.39 PM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Try this:

SUBSTITUTE(
  Name,
  RIGHT(
    Name,
    4
  ),
  "****"
)

Screenshot 2024-02-18 at 12.44.39 PM.png

This worked beautifully! Thanks a lot!