Skip to content

Instantly share code, notes, and snippets.

View kchatel's full-sized avatar

Kevin Chatel kchatel

  • SignatureWEB
  • Montreal, Quebec
View GitHub Profile
@kchatel
kchatel / ExcelRemoveAccents.vb
Created August 9, 2022 22:23 — forked from mpecka/ExcelRemoveAccents.vb
Excel Remove Accents
Function StripAccent(thestring As String)
Dim A As String * 1
Dim B As String * 1
Dim i As Integer
Const AccChars= "áäčďéěíĺľňóôőöŕšťúůűüýřžÁÄČĎÉĚÍĹĽŇÓÔŐÖŔŠŤÚŮŰÜÝŘŽ"
Const RegChars= "aacdeeillnoooorstuuuuyrzAACDEEILLNOOOORSTUUUUYRZ"
For i = 1 To Len(AccChars)
A = Mid(AccChars, i, 1)
B = Mid(RegChars, i, 1)
thestring = Replace(thestring, A, B)