Help

Formula for only last 4 digits

Topic Labels: Formulas
1354 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Carl-Henrik_Sjo
4 - Data Explorer
4 - Data Explorer

I want a formula to look at a string of 10 digits and only write the last 4. How would I do that?

1 Reply 1

Hi @Carl-Henrik_Sjostrom - try this:

RIGHT(Name, 4)

if the 10 digits is a string or:

RIGHT(Number & '', 4)

If the 10 digits is a number/integer

Screenshot 2019-05-03 at 13.59.35.png

JB