Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
If the first part of your alphanumeric column will continue to contain 6 places you could do something like =RIGHTYou can try =TEXT(YourColumnNameINT(RIGHT(Column,69)),"0") to convert it to text based.
If the first part of your alphanumeric column will continue to contain 6 places you could do something like =RIGHT(YourColumnName,6)
You can try =TEXT(INT(RIGHT(Column,9)),"0") to convert it to text based.
