Excel SUBSTITUTE Shortcut: Function and Replace Keys

Excel has no dedicated keyboard shortcut for the SUBSTITUTE function. To replace text in cells with a formula, enter =SUBSTITUTE(...); to open Excel’s Find and Replace tool on Windows, press Ctrl+H.

What “substitute” means in Excel

People asking for an “Excel substitute shortcut” may mean one of two things: a quick way to replace text throughout a worksheet, or a shortcut for the SUBSTITUTE worksheet function. They are related, but they do different jobs. Ctrl+H opens Find and Replace, where you can change matching entries directly. SUBSTITUTE creates a formula that returns text with specified characters or words changed.

Use Find and Replace when you want to edit existing cell contents in a selected range, sheet, or workbook. Use the function when you want a calculated result, need to preserve the original value, or want changes to update automatically when the source text changes. Neither method has a special “substitute” key that works in every context.

For example, replacing every instance of “North” with “West” in a set of existing labels is a good Find and Replace task. If the original labels must remain untouched while a second column displays the changed versions, a formula is usually more suitable.

SUBSTITUTE function syntax

The function’s syntax is SUBSTITUTE(text, old_text, new_text, [instance_num]). The brackets indicate that instance_num is optional; do not type the brackets in a formula. The arguments mean:

text is the text, or cell reference containing text, to change.
old_text is the exact sequence of characters to find.
new_text is the replacement text. Use "" if you want to remove the matching text.
instance_num specifies which occurrence to replace. Leave it out to replace every occurrence.

The function returns new text; it does not edit the source cell. It is case-sensitive, so “Excel” and “excel” are different matches. It looks for the specified characters as text rather than applying wildcard patterns such as * or ?. If you need to change a character by its position rather than match a known sequence, Excel’s REPLACE function is a different tool.

Basic examples with cell references

With the text “Blue Oak Supplies” in A2, enter this formula in B2 to change “Oak” to “Pine”: =SUBSTITUTE(A2,"Oak","Pine"). The result in B2 is “Blue Pine Supplies”; A2 remains “Blue Oak Supplies.” The formula replaces all matching instances, although this particular text contains only one.

With the text “2026/11/02” in A2, enter =SUBSTITUTE(A2,"/","-") in B2. The result is “2026-11-02,” because the slash appears twice and the formula replaces both instances. The result is still text, not an Excel date value. If you need a date for date calculations, convert or construct a real date value rather than assuming that changing the separators changes the underlying data type.

With “red, red, blue” in A2, enter =SUBSTITUTE(A2,"red","green",2) in B2 to change only the second occurrence. The result is “red, green, blue.” The optional fourth argument counts matches from left to right; it does not identify a character position.

To remove part of a value, use an empty replacement. With “INV-0042” in A2, enter =SUBSTITUTE(A2,"INV-","") in B2. The result is “0042.” If the remaining characters are digits stored as text, this formula does not automatically turn them into a number.

Use the keyboard shortcut for Find and Replace

In Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace. Type the text to look for in the “Find what” box and the new text in “Replace with.” Choose “Replace” to handle matches one at a time, or “Replace All” to change every match in the chosen search scope. Press Esc to close the dialog.

Before choosing Replace All, check the dialog’s options and scope. “Within” controls whether Excel searches the current sheet or the workbook; “Search” controls whether it searches by rows or columns; and “Look in” determines whether Excel searches values, formulas, or comments, where available. If you select a range before opening the dialog, Excel can limit the operation to that selection. Check the displayed replacement count and inspect the affected cells afterward.

In Excel for Mac, Control+H opens Find and Replace. Mac keyboards use the Control key for this shortcut; it is not the same as pressing Command+H, which can hide the current application in macOS. Excel for the web also provides Find and Replace through its interface, but keyboard behavior and available dialog options can vary by browser and version. If a shortcut is intercepted or does not open the expected tool, use the Excel ribbon or search for the command in the application.

Choosing between a formula and Replace All

Choose based on whether you want to change the source data or calculate a separate result. A formula is usually the more cautious option when you need to preserve the original text, review results before using them, or repeat the same transformation on new rows. Fill the formula down the adjacent column, check several results, and then decide whether to keep the formulas or copy and paste their results as values.

Find and Replace is faster for a deliberate, one-time edit to existing cells. It is also useful when you need to update a label across many sheets. However, Replace All changes the matching content in place, so a mistaken search term or scope can affect more cells than intended. If the workbook is important, save a copy before making a broad replacement.

Use SUBSTITUTE for repeatable, cell-by-cell transformations that should respond to changed source text.
Use Ctrl+H for a direct edit when you have checked the search term, replacement text, and scope.
Use a different method when the desired match depends on wildcards, position, or more complex rules; a simple SUBSTITUTE match is literal and case-sensitive.

Common problems and how to avoid them

The formula is displayed instead of its result. Check that the cell is not formatted as Text, and that the formula begins with an equals sign. If the cell was formatted as Text before entry, change it to General and re-enter the formula. Also check whether Show Formulas is turned on, which displays formulas across the sheet instead of their calculated results.

Nothing changes. The text to match may differ in capitalization, spacing, punctuation, or hidden characters. Because SUBSTITUTE is case-sensitive, a formula looking for “ACME” will not match “Acme.” Extra spaces are another frequent cause. Compare the source carefully, or create a small test formula that targets a shorter, known sequence.

Find and Replace changes too much. Confirm that “Within” is set to the intended sheet or workbook and that the selected range is correct. A short search term can appear inside unrelated words. Use “Replace” to review individual hits before using “Replace All,” especially when searching the entire workbook or searching within formulas.

The result looks like a date or number but behaves like text. Replacing punctuation changes characters, not the data type. A result such as “2026-11-02” may still be text, and a result such as “0042” may need to retain its leading zero. Decide whether the output is meant to be a label or a value for calculations before converting it.

Related functions and alternatives

SUBSTITUTE and REPLACE are easy to confuse. SUBSTITUTE searches for a particular piece of text and replaces its matches. REPLACE changes text starting at a specified character position for a specified number of characters. For example, replacing a known code such as “INV-” is a SUBSTITUTE-style task; changing characters 5 through 8 regardless of what they contain is a REPLACE-style task.

Find and Replace is not a worksheet function: it edits cells directly and does not leave a formula showing how the new text was produced. Conversely, a formula does not overwrite the original cell. For more involved cleanup, Excel’s Text to Columns, Flash Fill, or Power Query may fit better, depending on whether the task is splitting fields, recognizing a pattern, or transforming data during an import process. Those tools are alternatives, not shortcuts for the SUBSTITUTE function itself.

Frequently Asked Questions

What is the Excel shortcut for substitute?
There is no dedicated keyboard shortcut for the SUBSTITUTE function. Press Ctrl+H on Windows to open Find and Replace; on Excel for Mac, use Control+H.

Does SUBSTITUTE replace every occurrence?
Yes, if you omit the optional instance_num argument. If you provide a positive occurrence number, the function replaces only that occurrence of the matching text.

Is SUBSTITUTE case-sensitive?
Yes. It treats uppercase and lowercase letters as different, so the old text must match the capitalization in the source. Find and Replace has its own search options, including a case-matching option in supported desktop dialogs.

Can SUBSTITUTE remove text from a cell?
Yes. Set the replacement text to an empty string, written as "" in the formula. The function returns the remaining text in a new result; it does not erase or alter the original cell.

What is the difference between SUBSTITUTE and REPLACE in Excel?
SUBSTITUTE finds a specific text sequence, while REPLACE uses a starting character number and a character count. Choose the one that matches whether you know what text to find or where the change should occur.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.