Using Excel Functions to Find Last Occurrence of a Character

SUBSTITUTE: Substitutes new find last occurrence of character in string excel text for old text in a text string.