Substitute Excel Formula




Excel Formulas > Text Functions > SUBSTITUTE

« Rept | Substitute | Trim »

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

Buy Excel Formula E-book | Learn more about Excel Substitute Formula

More Text Functions : Concatenate | Find | Left | Len | Lower | Mid | Proper | Rept | Substitute | Trim | Upper | Value

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook