Substitute Function in Microsoft Excel

mes(74)

Published in

DTube

Words

285

Reading

2 min

Listen

Play

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:
Microsoft Excel: Graphing too many data points - Simple Solution:
Intro to Tables in Excel 2007:
Adding Secondary Vertical and Horizontal Axes in Microsoft Excel:
Converting Text to a Table using "Fixed Width Text to Columns" in Microsoft Excel:
Remove Trendline from the Legend in Microsoft Excel:
Trendline Slope and Intercept Formulas in Microsoft Excel:
ISERROR and ISERR Functions in Microsoft Excel:
Transparent Images in Microsoft Excel + Useful Tip:
Convert Time to number, seconds, hours and minutes in Microsoft Excel 2007:
Converting Numbers to Fractions in Microsoft Excel 2007:
Drop Down Lists with Microsoft Excel 2007:
Numbered Headings and Automated Table of Contents - Office Word 2007:
Microsoft Excel Tips: -2^2 = +4 and NOT -4!!!:
Skip Blanks when Graphing in Microsoft Excel:
Automate Formulas using INDIRECT() Function in Excel: .