nth occurance of a character in Excel

To find the last occurance of "," (comma) in a string in excel

=RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1,",","|",LEN(A1)-LEN(SUBSTITUTE(A1,",","")))))

This will find the last occurance of the string after the last "," (comma)

Read More