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
Bookmarks