Find and replace in every folder.

[Steved]

Hello from Steved

Can this be done please.

Find 4001 and replace with 4101

I've a folder named Mon-fri ( 74 folders )

Is it possible to use Find and Replace, have it look in all the 74 Folders,
find 4001 and replace with 4101, also look in the Sheet2, as some folders
have 2 worksheets.

Thankyou.

[Steved]

From Steved

I forgot to mention it is in Col A:A only

Thankyou.

"Steved" wrote:

> Hello from Steved
>
> Can this be done please.
>
> Find 4001 and replace with 4101
>
> I've a folder named Mon-fri ( 74 folders )
>
> Is it possible to use Find and Replace, have it look in all the 74 Folders,
> find 4001 and replace with 4101, also look in the Sheet2, as some folders
> have 2 worksheets.
>
> Thankyou.