MS EXCEL - Substitute and Find

MS EXCEL - Substitute and Find

=substitute(text,old, new)
Substitute old text with new text

EXAMPLE: Singh is replaced with kumari
“=SUBSTITUTE(A89,““Singh””,““Kumari””)“ Arti Kumari Chauhan

=Find(find_text,text) Find the position of one text within other text
EXAMPLE: g is at 9 position in Arti Singh Chauhan

9 =FIND(“g”,A89)