How do I change one repeated word in the spreadsheet to another?

L

Largo

If I've used a word multiple times in a worksheet and want to change them all
to another word. ie: all words"exhibit" changed to "show". How can I do this?
Thank you
 
P

Pete

Use Edit | Replace (or CTRL-H). Type exhibit in the Find What box, type
show in the Replace With box and click Replace All.

Pete
 
G

Gord Dibben

Largo

CTRL + a(twice in Ver. 2003) to select all cells.

Edit>Replace

What: exhibit
With: show

In options check "match entire cell contents" or not depending upon if
"exhibit" is in cells with other text or by itself.

Replace all


Gord Dibben Excel MVP
 
Top