How do I change one repeated word in the spreadsheet to another?
Largo
CTRL + a(twice in Ver. 2003) to select all cells.
EditReplace
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
On Thu, 15 Dec 2005 12:22:02 -0800, "Largo"
wrote:
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
|