How do I write a formula looking for values to the RIGHT of a ","

Question

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)))

Answer 1

Something like this?

RIGHT(text_field__c, FIND(",", REVERSE(Text_Field__c)) - 1)