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)
