Find and replace text
On the Text tab, Find/Replace (Find & Replace group) searches text regions only. The tooltip: find and replace text everywhere it appears in text regions on this worksheet.
Replace words in notes
- Open the Text tab and choose Find/Replace.
- The dialog title is Find & Replace Text.
- Enter the current phrase in Find.
- Enter the new phrase in Replace with.
- Optionally tick Match case.
- The line under the fields shows how many matches. Choose Replace All.
Headings, body notes, quotes, captions, and section titles are all text regions. Header and footer bands are included. Math expressions, plot titles you typed in a plot config, and list labels are not — those are other region types.
Variable names are a different command
To rename V_1 to V_applied in every formula, use
Find and replace variables
on the Math Format tab. Running text find on V_1 will not
change the math.