Oct 19, 2018 Click in the toolbar, then choose Show Find & Replace. In the search field, enter the word or phrase you want to find. Matches are highlighted as you enter text. To find words that match the capitalization you specify, or to restrict search results to the whole words you entered, click, then choose Match Case or Whole Words (or both). Click the arrow buttons to find the next or previous.
You can search for specific words, phrases, numbers, and characters, and automatically replace search results with new content that you specify. All visible text in tables, text boxes, shapes, and comments on all sheets is included in the search.
Numbers searches the result of a formula but doesn’t search within a formula.
Search for specific text
Remove Or Replace Text
Click in the toolbar, then choose Show Find & Replace.
In the search field, enter the word or phrase you want to find.
Matches are highlighted as you enter text.
To find words that match the capitalization you specify, or to restrict search results to the whole words you entered, click , then choose Whole Words or Match Case (or both).
Click the arrow buttons to find the next or previous match.
When searching for a value, Numbers matches only the value that’s displayed in a table cell, not the underlying value or formula. For example, if you’re looking for “1/2,” a search for “0.5” won’t find a match.
To see or clear recent searches, click the magnifying glass in the search field.
Replace found text
Find And Replace Text Macro
Click in the toolbar, then choose Show Find & Replace.
Click in the Find & Replace window, then choose Find & Replace.
You can also choose other options, such as Whole Words and Match Case, to refine your search.
Enter a word or phrase in the first field.
As you enter text, matches are highlighted. The first match is selected and highlighted in yellow.
Enter the replacement word or phrase in the second field.
Important: If you leave the Replace field blank, all instances of the text are deleted when you replace the found text.
Use the buttons at the bottom of the Find panel to review and change the text matches:
Replace All: Replaces all text matches with the replacement text.
Replace & Find: Replaces the selected match with the replacement text and moves to the next.
Replace: Replaces the selected match with the replacement text but doesn’t move to the next match.
Previous and Next arrows: Move to the previous or next match without making a change.
In a table cell, replacing a value updates both the displayed value and the underlying value. For example, if you replace “1/2” with “1/3,” the underlying value changes from “0.5” to “0.333333.”
You can’t replace matching text in table cells that contain a formula.