Excel 2003 search and replace question

[DarkCyber]

I have a bunch of Excel spread sheets and in field A2 in each of these spread sheets they all have the exact same entry. Is there a way to automatically change that text in all of these without having to manually open and change this field in each spread sheet?

Is there some kind of search and replace that will work across multiple spread sheets?

 

[Oldie]

Sheets in a single workbook or sheets in different workbooks? If they're all in a single workbook, just ctrl+click each sheet and then do your find/replace.

 

[DarkCyber]

Sheets in a single workbook or sheets in different workbooks? If they're all in a single workbook, just ctrl+click each sheet and then do your find/replace.

They are different workbooks, field A2 in each one.