Hi, I upgraded to excel 2003 from excel 2000. The 2003 version modified my hyperlinks putting %20 where there had blank spaces. I found why and took care of that problem, but, it didn't change what had been change. So I need to replace the %20 with blank spaces, and since I have thousands to do I was wondering if there was a way to do them all at once with a macro or something.

Thank you

Open your spreadsheet, press CTRL H, replace %20 with {space}