Hi,

How can I return the occurance number of the comma just before a
specific word, say for this example, before "Red"

Green, Blue, Purple, Red, Yellow, Orange

So I should get the result: 3

TIA.


--
JohnnyBGood
------------------------------------------------------------------------
JohnnyBGood's Profile: http://www.excelforum.com/member.php...o&userid=29783
View this thread: http://www.excelforum.com/showthread...hreadid=494903