Replacing last 4 characters with stars ***

Question

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.

Page 1 / 1

Try this:

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

Try this:

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

This worked beautifully! Thanks a lot!

TheTimeSavingCo · Accepted Answer

Try this:SUBSTITUTE(  Name,  RIGHT(    Name,    4  ),  "****")

chegyy · Answer

Try this:SUBSTITUTE(  Name,  RIGHT(    Name,    4  ),  "****")This worked beautifully! Thanks a lot!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded