Substitute and Replace functions are text functions. We explain how to use the Substitute and Replace functions in Microsoft Excel.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.