Encoder in a sheet please Help

Copper Contributor

can someone help me to build a encoder sheet 

i have a code for example 12-05-nk and i would like to encode it within a sheet i was able to amange to find the right formula to encode the first two elements or partially but now i stuck on element 3 (element4) please have a look and help me 


Screenshot 2024-01-29 022827.png

1 Reply


Could you attach a small sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?