That's because your sample data indicated a character on the left so the number part is taken from the right hand side ...