function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
pmozz01pmozz01 

Formula Field Help

I am trying to create a formula field that takes a text field and only displays the values after the hyphen.  For example, the text field contains XXX XX-ZZZ ZZZZ.  I only want the values ZZZ ZZZZ and want to remove the hyphen and everything before it.  This is the formula I have tried but it does not find the hyphen"

 

TRIM(RIGHT(Owning_Org__c, FIND("-",Owning_Org__c)))

 What this formula gives me is:  XX-ZZZ ZZZZ.  To complicate this further, the text is not the same length after or before the hyphen.  Any ideas on how to accomplish would be much appreciated!!!

Best Answer chosen by Admin (Salesforce Developers) 
pmozz01pmozz01

Thanks!!!! Works perfectly :)

All Answers

Jake GmerekJake Gmerek

Right( Owning_Org__c , (len(Owning_Org__c) -  FIND('-', Owning_Org__c)))

 

This should do the trick.

pmozz01pmozz01

Thanks!!!! Works perfectly :)

This was selected as the best answer
Jake GmerekJake Gmerek

No problem