In a worksheet, I have 15,000 links to data files as follows:

'C:\Data\A\1\[DataA1]
'C:\Data\A\2\[DataA2] and so on.....

I would like to replace them as follows:

'C:\Data\B\1\[DataB1]
'C:\Data\B\2\[DataB2] and so on ....

As you can see, I only want A to be changed to B, however, when I use Find &
Replace, it will prompt me the location of the new link file for every single
replacement.. 15,000 !. Pls help. Thanks