SUBSTITUTE Function in Excel: How to Replace Text with Ease

Learn how to use the SUBSTITUTE function in Excel to quickly and easily search and replace text. Understand the syntax and different applications of the SUBSTITUTE function, such as replacing multiple words in a single cell. A beginner's guide to mastering the powerful tool of Excel.


Tired of nonsense pricing of DocuSign?

Start taking digital signatures with BoloSign and save money.

The SUBSTITUTE function in Excel is a powerful tool for replacing text in a cell. It makes it easy to search for a specific word or phrase and replace it with another word or phrase. This feature is especially useful when dealing with long pieces of text or multiple different words that need to be changed.

The basic syntax for the SUBSTITUTE function is =SUBSTITUTE(text, old_text, new_text). In this case, “text” would be the cell that contains the text you want to modify, “old_text” would represent the text that you want to replace, and “new_text” would be the text that you want to insert in its place.

For example, if you had the following sentence in a cell: “I love cats and dogs.” And you wanted to replace “cats and dogs” with “hamsters and rabbits”, you would use the formula =SUBSTITUTE(A1, “cats and dogs”, “hamsters and rabbits”). This would result in the sentence “I love hamsters and rabbits.” being displayed in the cell.

Another useful application of the SUBSTITUTE function is searching and replacing multiple words at once. You can do this by using the function in a loop and adding additional SUBSTITUTE functions in the same formula. For example, if you wanted to search and replace the words “cats”, “dogs”, and “birds” you could use the following formula: =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,”cats”,”hamsters”), “dogs”, “rabbits”), “birds”, “ferrets”).

In conclusion, the SUBSTITUTE function in Excel can be an invaluable tool for replacing text quickly and easily. With a few simple modifications, you can use the SUBSTITUTE function to search and replace multiple words at once and make complex changes to text in a single cell.


Paresh Deshmukh

Co-Founder, BoloForms

28 Feb, 2023

Take a Look at Our Featured Articles

These articles will guide you on how to simplify office work, boost your efficiency, and concentrate on expanding your business.