if A1 contains A56

in B1 =right(A1,2)*1 will return 56

in C1 =B1-4 will return 52

So instead of =Value(56) try =56*1