how can i subtract AAAA1234 - AAAA1220?
F Fred Smith Oct 6, 2006 #2 What result do you want. 4? AAAA0004? Something else? If you want 4, you can get this by: =right(b1,4)-right(a1,4)
What result do you want. 4? AAAA0004? Something else? If you want 4, you can get this by: =right(b1,4)-right(a1,4)
B Bob Phillips Oct 6, 2006 #3 =IF(LEFT(A1,4)=LEFT(A2,4),LEFT(A1,4)&(--RIGHT(A1,LEN(A1)-4)-RIGHT(A2,LEN(A2) -4)),"indeterminate") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
=IF(LEFT(A1,4)=LEFT(A2,4),LEFT(A1,4)&(--RIGHT(A1,LEN(A1)-4)-RIGHT(A2,LEN(A2) -4)),"indeterminate") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
