In this video I go over how to use the very useful Substitute function in Microsoft Excel. This function makes it possible to quickly replace a word or phrase in a cell or sentence as well as specific instances of that word or phrase. This can help save you a lot of time if you have lots of data that need to have a few words replaced! I used Microsoft Excel 2013 but this should be the same method for any other version of Microsoft Excel.
Download the Excel file in my video: https://1drv.ms/x/s!As32ynv0LoaIg5o9UJC8ndDYd8mj8w?e=7Zj2h6
Related Videos:
Microsoft Excel: Data Bars within Cells: http://youtu.be/EjvAhSLmJgw
Microsoft Excel: Graphing too many data points - Simple Solution: http://youtu.be/jKwFDR5X1ZY
Intro to Tables in Excel 2007: http://youtu.be/B_zXmunqrl4
Adding Secondary Vertical and Horizontal Axes in Microsoft Excel: http://youtu.be/fhPyaWzIQVk
Converting Text to a Table using "Fixed Width Text to Columns" in Microsoft Excel: http://youtu.be/wOpcnsMHb6Y
Remove Trendline from the Legend in Microsoft Excel: http://youtu.be/njp-zx_5Dq0
Trendline Slope and Intercept Formulas in Microsoft Excel: http://youtu.be/DTDY9RL35b8
ISERROR and ISERR Functions in Microsoft Excel: http://youtu.be/MrZLtpsLktM
Transparent Images in Microsoft Excel + Useful Tip: http://youtu.be/uKjtsQZ5Ow0
Convert Time to number, seconds, hours and minutes in Microsoft Excel 2007: http://youtu.be/fwMKbXI98tI
Converting Numbers to Fractions in Microsoft Excel 2007: http://youtu.be/YgJBK0QjIec
Drop Down Lists with Microsoft Excel 2007: http://youtu.be/e7Sbcn-y9j4
Numbered Headings and Automated Table of Contents - Office Word 2007: http://youtu.be/e00xCQ0MClg
Microsoft Excel Tips: -2^2 = +4 and NOT -4!!!: http://youtu.be/9QC3ZboI3wo
Skip Blanks when Graphing in Microsoft Excel: http://youtu.be/HcCJVUd7a5Q
Automate Formulas using INDIRECT() Function in Excel: http://youtu.be/9WiBtrNq9yU .
SUBSCRIBE via EMAIL: https://mes.fm/subscribe
DONATE! ʕ •ᴥ•ʔ https://mes.fm/donate
Like, Subscribe, Favorite, and Comment Below!
Follow us on:
Official Website: https://MES.fm
Steemit: https://steemit.com/@mes
Gab: https://gab.ai/matheasysolutions
Minds: https://minds.com/matheasysolutions
Twitter: https://twitter.com/MathEasySolns
Facebook: https://fb.com/MathEasySolutions
LinkedIn: https://mes.fm/linkedin
Pinterest: https://pinterest.com/MathEasySolns
Instagram: https://instagram.com/MathEasySolutions
Email me: [email protected]
Try our Free Calculators: https://mes.fm/calculators
BMI Calculator: https://bmicalculator.mes.fm
Grade Calculator: https://gradecalculator.mes.fm
Mortgage Calculator: https://mortgagecalculator.mes.fm
Percentage Calculator: https://percentagecalculator.mes.fm
Try our Free Online Tools: https://mes.fm/tools
iPhone and Android Apps: https://mes.fm/mobile-apps
▶️ DTube
Thank you for using the recommended tag/s. This post has been manually rewarded with BUILD tokens in the form of an upvote. You can buy, stake, and exchange our "BUILD" tokens for steem on steem engine or SteemLeo
Build-it is a central hub for DIY and How-To projects. It's an opportunity to find and share the latest in DIY, and How-To tutorials. The recommended tags required when creating a DIY article are #diy, #build-it. #how-to, or #doityourself. Please subscribe to our community here
Chat with us on our discord and telegram channels Discord, Telegram.