I want a formula to look at a string of 10 digits and only write the last 4. How would I do that?
Formula for only last 4 digits
+18Hi @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
JB
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.