Multiple Find & Replace text in cells from a list

[ericcellis]

Hello,
I really need help! I build my website off of a very large excel file. I add new product frequently and the text I get from my vendor has symbols and characters that cause the web pages to fail being generated. I know what symbols and characters to do find and replaces for but there are about 20 different find and replaces that I have to do. This ends up taking FOREVER!!!

I want to know, is there a way to make a seperate workbook that has a list of the problem symbols and characters, and then somehow have find replace go down the list and do each find and replace on the workbook that builds my webpages? I would like the list to be in a seperate workbook because I have multiple workbooks for my website so it would be easier if I only had 1 workbook to update the find and replace data.

This procedure really takes a lot of time so it would really help me out if I could automate it somehow.

Here is an small example of what I am needing to find and replace (note: Each item below, in the html code, would have a ; at the end but I had to remove it so the code would show up on this site.)
Ampersand + a space: &amp
Quote:" to &quot (this is actually a non-standard quote - like the ones where the quote at the beginning is one direction and the end one is the other direction or upside down.)
Copywrite:© to &copy
Registered:® to &reg
Trademark:™ to &trade
à to &agrave
è to &egrave
á to &aacute
é to &eacute
í to &iacute

Thank you so much for your help!!!
Eric

 

[ericcellis]

Ok, thanks for the help! I really appreciate it. It's kinda funny, long ago I used basic with DOS. I can see some parts of it in the code but it sure has a lot more in it now. I think I dumped that part of my brain many years ago from lack of use. The only thing I remember is
10 print "Beep"
15 sound=16000
20 for i=1 to 8000; next i
25 goto 10

I used to run this when I left class. hahaha how stupid. (not 100% sure on line 20 if I got it all right for a pause)

Thanks again for the help.