Replace text automatically in Numbers on Mac
You can set Numbers to automatically replace certain text with text that you specify. For example, you can have Numbers replace teh with the or (c) with © as you type.
You can also replace all instances of specific text in your spreadsheet with other text you define.
Replace text as you type
Choose Numbers > Preferences (from the Numbers menu at the top of your screen).
Click Auto-Correction at the top of the preferences window.
In the Replacement section, select the tickbox next to “Symbol and text substitution”.
Click , then type the text you want to replace (such as “teh”) in the Replace column.
In the With column, type the word you want to replace it with (such as “the”).
You can also Use accents and special characters in Numbers on Mac as replacements.
Press Return to save the change.
These text substitutions apply only to Numbers.
Replace existing text in a spreadsheet
If you want to replace specific text that appears in multiple places in your spreadsheet, you can add the replacement text to your computer’s Keyboard preferences, then use the Substitutions window to replace the text wherever it occurs.
With the spreadsheet open, choose Edit > Substitutions > Show Substitutions (from the Edit menu at the top of your screen).
In the Substitutions window, select the Text Replacement tickbox, then click Text Preferences.
The Text pane of Keyboard preferences opens (it’s part of your computer’s System Preferences).
Click the Text tab.
Click , then type the text you want to replace (such as change) in the Replace column.
Type the word you want to replace it with (such as modify) in the With column.
After your last entry, press Return, then close the preferences window.
Do one of the following:
Replace all occurrences of the text: In the Substitutions window, click Replace All. If you have other substitutions in Keyboard preferences, they are also applied to your spreadsheet.
Apply replacements to specific text: Select the text you want to modify, then in the Substitutions window click Replace in Selection.
Note: Text replacement settings in Keyboard preferences apply to other applications on your computer, such as TextEdit, Pages and Keynote, when they have text substitution turned on.