Altering all references in an excel worksheet

[Adam Stephenson]

Hi,
I have a 100+ sheet excel worksheet. In it I have multiple references to a number of different subjects. Can I write a function to change all references from one word to another.
For example I want all instances of 'Adapt' changed to 'TriSys'.

Thanks

[oldchippy]

Hi,

Have you tried Find/Replace on the Edit menu?

[Adam Stephenson]

Thanks, that works perfectly!

[oldchippy]

Glad to hear it - thanks for the feedback