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

[Guest]

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

 

[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

 

[Pete]

Sorry, I should have said highlight the block of cells first, then
CTRL-H.

Pete

 

[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

 

[Guest]

Ctrl+H

 

[wjohnson]

Select the column('s) and go to EDIT - Find and Replac