Explaining The Excel Substitute Function

Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials
***************

It happens in a few circumstances. I bring data from the internet or some type of document and find myself with a bunch of data that I need to rearrange. Just take a look at this spreadsheet for example. When you look at it, it looks perfectly fine right?

Suppose that you need to change all of the “.TO” to “-CA”, how would you do it? You could use the right function. If the text to replace can be found anywhere in the string, you might need to use the find function as well.

Even easier though is the usage of the substitute function such as follows:

=SUBSTITUTE(TEXT, text to find, text to replace it with)

So in this case that becomes:

=SUBSTITUTE(A2,”.TO”,”-CA”)

You can see the result here:

And download the spreadsheet here

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

Comments

Please Leave a Comment!





Please note: Comments may be moderated. It may take a while for them to show on the page.