apgmin
Board Regular
- Joined
- Mar 1, 2010
- Messages
- 143
- Office Version
- 2013
- Platform
- Windows
In column A
I have the list of districts
Agar-Malwa
Alirajpur
Anuppur
Ashoknagar
Balaghat
Barwani
Betul
Bhind
Bhopal
Burhanpur
Chhatarpur
Chhindwara
Damoh
Datia
Dewas
Dhar
Dindori
In column B : I need a formula such that I can generate 2 unique characters to denote the districts
Similar to the 2 letters that denote the states in US like Alabama and Alaska both have the first 2 letters common but they are denoted by AL and AK
I need exactly something like this
I have the list of districts
Agar-Malwa
Alirajpur
Anuppur
Ashoknagar
Balaghat
Barwani
Betul
Bhind
Bhopal
Burhanpur
Chhatarpur
Chhindwara
Damoh
Datia
Dewas
Dhar
Dindori
In column B : I need a formula such that I can generate 2 unique characters to denote the districts
Similar to the 2 letters that denote the states in US like Alabama and Alaska both have the first 2 letters common but they are denoted by AL and AK
I need exactly something like this