Formula question

Question

Hello Community,

I am trying to create a formula that will return the number after the " ; " in the following example strings:

Jim Simpson;25

Would return 25 as a number.

Matthew-Bennett J Lewis;100

Would return 100 as a number.

Can anyone help me out with this?

Thank you!

Keiji Otsubo · Accepted Answer

Hi  @Nick Salpas https://trailblazers.salesforce.com/profileView?u=0054S0000019FOTQA2  ,   Try this   RIGHT( field__c ,LEN(field__c) - FIND(';', field__c ))

Steven Trumble · Answer

You might need to wrap that formula inside a VALUE() function: VALUE( RIGHT( field__c ,LEN(field__c) - FIND(';', field__c )) )

Formula question

* Salesforce Administrators *

More Help