SUBSTITUTE Function in Excel: How to Replace Text with Ease

28 Feb, 2023
paresh
Paresh @Boloforms
1 min read
BoloForms

Create a free BoloForms account today!

Create your free account today and start creating your own digital signature.

Create Free Account

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.

Limited-time offer
Get lifetime access to BoloForms Signatures for FREE!
Includes :
Collect Signatures inside Forms (5 submissions/mo)
Send for Signature (1 document/mo)
5 Forms- Generate Custom PDFs based on Form Submissions
1 PDF Template
Free Contracts Templates
24/7 support
Notifications and Reminders
Audit Log and History
BoloForms Signature Branding

(act fast as this exclusive offer won't last forever!)

Free Forever
No credit card required