Tap
, then tap Find.
Tap
, then tap Find & Replace.
Enter a word or phrase in the left text field.
As you enter text, the number of matches appears alongside it. The first match you can edit is highlighted in yellow.
Do any of the following:
Replace all matches with the same replacement text: In the right text field, enter replacement text. Touch and hold Replace, then tap Replace All.
Important: Leaving the right text field blank deletes all instances of the found text.
Replace different matches with different text: In the right text field, enter replacement text, then tap Replace. Continue tapping Replace to apply the same replacement text, or enter different replacement text and tap Replace.
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.