Skip to main content

Formula for only last 4 digits

  • May 3, 2019
  • 1 reply
  • 53 views
C

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

JonathanBowen
Forum|alt.badge.img+18

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

JB

C
Justin_Barrett
Terms & ConditionsAccessibility statement