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.

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.

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can …

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can …

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 immediately …

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 subscription benefits, …

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

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. Start_num …

Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

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 subscription benefits, …

Lists all Excel functions by their category, such as Logical functions or Text functions.