Skip to main content

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.

Try this:

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


Try this:

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


This worked beautifully! Thanks a lot!