Find/replace html codes with special characters

[pselva01]

I have spreadsheets generated from an online database. The site exports special characters as html strings--i.e., ö in place of ö,

in place of ", etc.

I often have to google the individual html codes and then run find/replace searches to get rid of the code and replace it with the human-readable special character, which ends up taking a significant amount of time.

Is there an easier way to do this? I little-to-no experience working with macros or VBA.

I'm using Excel 2007 on Windows XP.

Thanks for any and all help!

 

[nicolewh]

open up a module and place this code in it and then activate it

Sub ReplaceHTML()
    Cells.Activate
    Selection.Replace What:="ö", Replacement:=""""
End Sub

Goodluck!
Nicole