This article describes the formula syntax and usage of the SUBSTITUTE function in Microsoft Excel. Description Substitutes new_text for old_text in a text string. Use SUBSTITUTE when …

Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

You can search by rows and columns, search within comments or values, and search within worksheets or entire workbooks. Tip: You can also use formulas to replace text. To learn …

Lists Text functions, such as the Clean, Proper, and Trim functions.

Word for the web lets you find and replace basic text. You can match case or fine whole words only. For more varied options, open your document in Word for the desktop. Explore …

REPLACE (old_text, start_num, num_chars, new_text) The REPLACE function syntax has the following arguments: Old_text Required. Text in which you want to replace some characters. …

Word for the web lets you find and replace basic text. You can match case or fine whole words only. For more varied options, open your document in Word for the desktop. Explore …

When you replace formulas with their values, Excel permanently removes the formulas. If you accidentally replace a formula with a value and want to restore the formula, select Undo …

A complete list of all Excel functions in alphabetical order.

Because these characters are not easily noticed, the unexpected results may be difficult to understand. To remove these unwanted characters, you can use a combination of the TRIM, …

Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These …