You need to sign in to do that
Don't have an account?
cldave
Formula to Extract only the Numbers from a field
Hi,
I have a field which contains Social Security # and in the US it's formated this way: EX: 123-45-7890
Now i need to create a formula field to show only the numbers from that field without any other character like "-"
So result should be ;EX: 123457890
Can anyone pls help me with the syntax?
Thank you in advance
I have a field which contains Social Security # and in the US it's formated this way: EX: 123-45-7890
Now i need to create a formula field to show only the numbers from that field without any other character like "-"
So result should be ;EX: 123457890
Can anyone pls help me with the syntax?
Thank you in advance
Shashikant
All Answers
(remember to replace Social_Security_Number__c with the field name for your actual field.
Shashikant
And works only if you give the return type as Text and not Number.
Thanks,
Shyama
@cldave - Happy that it helped you.
Thanks
Hi cldave,
You can try this:
SUBSTITUTE(SSN__c, '-', '')
Please mark it as Best Answer if it helps!
Thanks