Using the Excel SUBSTITUTE Function

Learn how to use the Excel SUBSTITUTE function to make changes to specific ranges of your text. Works like magic! ***Support Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Consider saying "Thanks" by clicking the Thanks button below the video. Here's a link to the practice file for this video: bit.ly/excelsubstitute #excel #exceltutorials #microsoft365

[@assatakamara93]

THANKS FOR SHARING

[@jeyavenim6547]

Thank you so much sir very useful video keep going 👍

[@melissaavilez8784]

Thank you. Can you substitute multiple texts at the same time?

[@epal6964]

thanks

[@CAPSTONEization]

what is the Substitute command for replacing text between the quotes, and text varies from cell to cell. Ex: A0 -> I have "Apple13" phone, A1 -> -> I have "Apple14" phone. I want to substitute text between "" in both A1 and A2 to "Apple".

[@blessedowo1958]

Thanks bro

[@LukeMatanin]

What if you need to replace quotations " (the inches symbol)?

[@LukeMatanin]

example remove " from 15" so that it just equals 15

[@ikkusoft]

❤