Al bu da o fonksiyon:
Function Temizle(Ron)
Ron= Replace(Ron,"Ğ","g", 1, -1, 1)
Ron= Replace(Ron,"ğ","g", 1, -1, 1)
Ron= Replace(Ron,"Ş","s", 1, -1, 1)
Ron= Replace(Ron,"ş","s", 1, -1, 1)
Ron= Replace(Ron,"Ö","o", 1, -1, 1)
Ron= Replace(Ron,"ö","o", 1, -1, 1)
Ron= Replace(Ron,"Ç","c", 1, -1, 1)
Ron= Replace(Ron,"ç","c", 1, -1, 1)
Ron= Replace(Ron,"Ü","u", 1, -1, 1)
Ron= Replace(Ron,"ü","u", 1, -1, 1)
Ron= Replace(Ron,"I","i", 1, -1, 1)
Ron= Replace(Ron,"ı","i", 1, -1, 1)
Ron= Replace(Ron,"İ","i", 1, -1, 1)
Ron= Replace(Ron," ","-", 1, -1, 1)
Ron= Replace(Ron,",","", 1, -1, 1)
Ron= Replace(Ron,".","", 1, -1, 1)
Ron= Replace(Ron,"`","", 1, -1, 1)
Ron= Replace(Ron,"'","", 1, -1, 1)
Ron= Replace(Ron,"?","", 1, -1, 1)
Ron= Replace(Ron,"!","", 1, -1, 1)
Ron= Replace(Ron,"(","", 1, -1, 1)
Ron= Replace(Ron,")","", 1, -1, 1)
Ron= Replace(Ron,"""","", 1, -1, 1)
Ron= Replace(Ron,"!","", 1, -1, 1)
Ron= Replace(Ron,"/","", 1, -1, 1)
Ron= Replace(Ron,"\","", 1, -1, 1)
Ron= Replace(Ron,"é","", 1, -1, 1)
Ron= Replace(Ron,"\","", 1, -1, 1)
Ron= Replace(Ron," - ","-", 1, -1, 1)
Ron= Replace(Ron,":","", 1, -1, 1)
Ron= Replace(Ron,")","", 1, -1, 1)
Ron= Replace(Ron,"(","", 1, -1, 1)
Ron= Replace(Ron,"@","", 1, -1, 1)
Ron= Replace(Ron,"ß","b", 1, -1, 1)
Ron= Replace(Ron,"%","", 1, -1, 1)
Ron= Replace(Ron,"+","_", 1, -1, 1)
Ron= Replace(Ron,";","_", 1, -1, 1)
Ron= Replace(Ron,"^","_", 1, -1, 1)
Ron= Replace(Ron,"â","_", 1, -1, 1)
Ron= Replace(Ron,"Â","_", 1, -1, 1)
Ron= Replace(Ron,"ê","_", 1, -1, 1)
Ron= Replace(Ron,"Ê","_", 1, -1, 1)
Ron= Replace(Ron,"ô","_", 1, -1, 1)
Ron= Replace(Ron,"Ô","_", 1, -1, 1)
Ron= Replace(Ron,"û","_", 1, -1, 1)
Ron= Replace(Ron,"Û","_", 1, -1, 1)
Ron= Replace(Ron,"~","_", 1, -1, 1)
Temizle = lcase(Ron)
End Function