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:
Reviewed by Unknown
on
23:48
Rating:
Welcome to our Expert community, How many questions do you have about excel? are you still serching for an answer? dont worry ask any questions and get answer instantly.
No comments: