Macro for Azerbaijani alphabet Find-Replace

[heyvan]

Hey everyone,

I'm currently working on a project that needs quite a lot of find-replace work. It has got mainly to do with the difficulty of transliterating Azerbaijani letters to English. I am looking to design a maro that will take the list of Azerbaijani letters found in cells on a sheet and convert to their appropriate latin equal.

Example
Ə to A
ə to A
Ö to o
ö to ö
Ü to U
ü to u
Ğ to G
ğ to g
Ç to Ch
ç to ch
Ş to Sh
ş to sh
İ to I (capital letter I in Azerbaijani has got a dot on top)

I have tried several VBA option but none work all too well as I am quite inexperienced. What would be your go-to script in this case?

[ag273n]

i created something for yah

but you need to follow my instructions (strictly) so this can work, this is tested and it works

1. create a worksheet on the workbook you intend to use this. Name it "Character" (if the spelling is wrong it wont work).
2. on this sheet ("Character") on Column A - Row 1 , Put a header - you can name it "Character"
3. Below this column you put the special Characters that'll be replaced by the code - you can add as many characters needed - even a thousand..

4. on the same sheet - on Column B - Row 1, put on a header - you can name it "Replace" or anything...
5. on this column, you need to add the equivalent letters on the adjacent cells
6. that sheet (Character) can be hidden - it should still work, but it will not work without that sheet...

now you need to add a module for this
1. google how to add a module into the workbook you need, if you already know how to add a module, below is the script you can add..

Please Login or Register  to view this content.

2. i attached a sample workbook you can check out...

so 2 requirements for this to work - the worksheet (Characters) and the script above...


Book1.xlsm

[heyvan]

Thanks a bunch my friend!

The only issue is that the script is not case sensitive. This is particularly problematic considering the capital İ to I transform is the most difficult bit. Any pointers in that regard?