EditReplace should get you there.

Replace what: JAN!

Replace with: FEB!


Gord Dibben MS Excel MVP

On Wed, 9 Jan 2008 11:41:01 -0800, Harley
wrote:

I need to change ref's (month's) within many formulas. Is there a shortcut to
help expidite this. For example, I have numerous formulas relating to each
month. I need to change all "JAN" refs to "FEB" refs for the appropriate
worksheet without having to retype each formula.

thanks,

Harley