What is the use of Substitute formula?
Substitutes one text with another in the given text
Syntax of Substitute formula:
substitute(in this text, this text, with this text, [at this occurance])
Examples of Excel Substitute formula:
substitute("Pointy Haired Dilbert", "Pointy", "Curly") = Curly Haired Dilbert
substitute("123-123-1234","-","") = 1231231234
That’s all for now. If you want to add any tip then feel free to comment below. Thanks. And Subscribe to blog feed to receive updates about new posts !
How to calculate substitue formula in Microsoft Excel.
Reviewed by Unknown
on
23:48
Rating:

No comments: