Excel - replacing Text in workbooks

[Guest]

How do I find and replace text in multiple workbooks at once? I am
translating a budget that is compiled of multiple workbooks and wish to have
Excel cahnge one word in many workbooks.

 

[Harlan Grove]

How do I find and replace text in multiple workbooks at once? I am
translating a budget that is compiled of multiple workbooks and wish
to have Excel cahnge one word in many workbooks.

You have to do this one workbook at a time. You could use a macro to
iterate through all these workbooks, changing this one word in each.