Formula show #ERROR! when Substitute from a Number...

[Nathan_Ramey]

Hello everybody! Inside my base we have 10-digit codes for each of our users for passwords and such. I was wondering if I could somehow use a formula field to only show a select few digits of that code. Similar to a phone number when they send you a confirmation text you can only see the last four.

Thanks!

[Vivid-Squid · Accepted solution]

Hi @Nathan_Ramey
Yes, you can use either the LEFT(), RIGHT() or MID() formula to extract from the string.

If you want the last 4 try this:

RIGHT({10 Digit Code},4)

[Nathan_Ramey]

Thanks! I didn’t know about these formulas!