Replacing last 4 characters with stars ***

[chegyy]

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.

[TheTimeSavingCo · Accepted solution]

Try this:

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

[chegyy]

This worked beautifully! Thanks a lot!