How do I write a formula looking for values in a separate field to the RIGHT of a comma.

So if I have field A that lists out "Red, White, Blue"

How do I write a formula in field B that returns "Blue"

I've written the below formula but it gives me everything after the first comma - so in this case "White, Blue" - when all I need is Blue

TRIM(RIGHT(Text_field__c, LEN(Text_field__c)-FIND(",",Text_Field__c)))


1 Answer 1


Something like this?

RIGHT(text_field__c, FIND(",", REVERSE(Text_Field__c)) - 1)
  • That worked!!! Thank you so much. Aug 10 at 18:32

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .