Advertisement
Guest User

Untitled

a guest
Feb 20th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     Cells.Replace What:="À", Replacement:="A", LookAt:=xlPart, SearchOrder _
  2.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  3.     Cells.Replace What:="È", Replacement:="C", LookAt:=xlPart, SearchOrder _
  4.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  5.     Cells.Replace What:="Æ", Replacement:="E", LookAt:=xlPart, SearchOrder _
  6.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  7.     Cells.Replace What:="Ë", Replacement:="E", LookAt:=xlPart, SearchOrder _
  8.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  9.     Cells.Replace What:="Á", Replacement:="I", LookAt:=xlPart, SearchOrder _
  10.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  11.     Cells.Replace What:="Ð", Replacement:="S", LookAt:=xlPart, SearchOrder _
  12.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  13.     Cells.Replace What:="Ø", Replacement:="U", LookAt:=xlPart, SearchOrder _
  14.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  15.     Cells.Replace What:="Û", Replacement:="U", LookAt:=xlPart, SearchOrder _
  16.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
  17.     Cells.Replace What:="Þ", Replacement:="Z", LookAt:=xlPart, SearchOrder _
  18.         :=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement