Skip to main content
Solved

Replacing last 4 characters with stars ***

  • February 17, 2024
  • 2 replies
  • 27 views
C
Forum|alt.badge.img+2

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.

Best answer by TheTimeSavingCo

Try this:

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

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Try this:

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

Adam, Airtable Consultant - thetimesaving.company
C
C
Forum|alt.badge.img+2
  • chegyy
  • Author
  • New Participant
  • February 18, 2024

Try this:

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


This worked beautifully! Thanks a lot! 

Terms & ConditionsAccessibility statement