No, it could be random numbers or alphabets. For example 8AND00009-01234567 OR APMYV222-26788. I need to extract two parts from these two examples, 8AND from ex)1 and APMYV from ex )2. I also need to fill another column with numeric values left of the alphabets and right of the "-" excluding zeros. In the example above, I need "9" and "222"