The Substitute function in Microsoft Excel replaces a specific text in a text string with a different text. The Replace function replaces part of a text string based on the number of characters ...

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.

A. Use the SUBSTITUTE function to replace one string of text with another Function syntax: The syntax (or sentence structure) of the SUBSTITUTE function is this: ...

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.