how can i subtract AAAA1234 - AAAA1220?

  • Thread starter Thread starter Guest
  • Start date Start date
What result do you want. 4? AAAA0004? Something else?

If you want 4, you can get this by:

=right(b1,4)-right(a1,4)
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Subtracting time...again 2
Workday Formula to include date 0
subtract 1
Excel Subtract text after the third space and before the fourth (from between spaces) 3
incorrect subtraction 3
Excel Having trouble subtracting one cell from another and storing the result. Pls help. 3

Back
Top