Edit multiple hyperlinks simultaneously?

[Barquentine]

I have several hundred hyperlinks (music tracks listed in a spreadsheet linked to mp3 files) - which worked fine; both the link and the source file were on my hard drive. Then I transferred the spreadsheet and mp3 files onto a usb stick. Now the address in the hyperlink still points to the old directory they were in but the directory letter has changed. I can change one at a time (and they work again) - but I can't do each one manually. I cannot figure out how to make all the hyperlinks point to the correct directory address.
Does anybody know how? Many thanks.

[MarkRae]

Click Ctrl-H, enter the text to be replaced and the text to replace it with, and click Replace All

[Barquentine]

Thanks MarkRae. First I select all the cells with hyperlinks in? When I select FindAll it does not seem able to find the hyperlink formula inside the cell?

[Barquentine]

Instead of doing it this way I went into Control Panel and System Maintenance and found you can change the drive letter of the usb memory stick to that used by all the hyperlinks which now work again!