Permalink Maker with VBA

[zeroist]

Hi everybody,

In column A I have list of topics.I want to convert those topics to permalink format.for this Column A needs

1. first column A has to be converted into lowercase
2. then non-english letters converted to english by converting ç,ü,ş,ğ,ö,ı into c,u,s,g,o,i
3. characters other then letters and numbers (space included) need to be converted into Hyphen(-)
4. if there is more than one Hyphen,it must be reduced to one Hyphen.
5 if last and first character is Hyphen,they are omitted.
ex: çÜşĞÖı (ALı)

1. çüşğöı (alı)
2. cüsgoi (ali)
3. cüsgoi--ali-
4. cüsgoi-ali-
5.cüsgoi-ali

here is the sample.what is needed is in page2...sample.xlsx

[rcm]

run the macro.

an equivalence list needs to be revised and completed in sayfa3. Results are in column B of shayfa1

[zeroist]

Hi rcm,

It is almost ok.but b2 and b7 still have two Hyphen.And convertion of ı into i not works.

[rcm]

got it!!!! here is the revised version that takes care of the hyphens.. In sayfa3 just type the special character in column a and its equivalent in column B