What is the use of Substitute Function and how we can use of it
Excel SUBSTITUTE Function can be used to replace one or more instances of any specific character or sub string in a give text string. The function is case-sensitive and does not support wild-card characters as well. Watch Here!