Select Text further right

[Sundance_Kid]

Hi,

I have a column with text in each of the rows, a mix of 1, 2 & 3 words such as

Green
Green, Red
Green, Red, Yellow

Is there a formula that will select the word/text on the far right, so that in the above example the following is pulled:

Green
Red
Yellow

Thanks

 

[Fluff]

How about

Fluff.xlsm
	A	B
1
2	Green	Green
3	Green, Red	Red
4	Green, Red, Yellow	Yellow
Data

Cell Formulas
Range	Formula
B2:B4	B2	=TRIM(TEXTAFTER(A2,",",-1,,1))