I'm hoping someone would be kind enough to help me come up with a macro that does a find and replace. Basically I have a worksheet that has html in many cells. I need to be able to replace the html with a token... so for example:
cell1: This is the first cell and it has html to <a href="http://www.excelforum.com/">Excel</a> in it.
I need to replace the html string in each cell with "%LINK1%". The html is different in each cell though, so the macro needs to be able to find a string that starts with "<a" and ends with "a>" or anything similar, as long as the entire string is replaced.
Any help would be greatly appreciated. Thanks!
Bookmarks