Calculate number between two alphanumeric cells

[Jennifer Medina]

I need to calculate the difference between two alphanumeric cells. For example:

Column 1 Column 2
A16 A23 = 7

I have more complex alpha numeric strings such as:

Column 1 Column 2
1A732S 8C712E = ?

Any help would be appreciated

 

[JE McGimpsey]

So with your latter examples what do you expect as a result?

8 - 1?

712 - 732?

8712 - 1732?

 

[Jennifer Medina]

I need the calculation to include the amout of difference in the letters as
well, like A1-B1 = 26 or A1-C1=52

 

[RagDyer]

In your second example, are you only concerned with the 732 and the 712, or
are there other considerations?

How about more examples of possible combinations?

 

[JE McGimpsey]

Your examples are still ambiguous. Will the letters and numbers always
be in the same places?

If not, what would be the expected result for

A1 - 11

? Regardless, how should two letters together be handled:

AA16 - FC23

(e.g., each letter separately, or as a base-26 number)?? Is something
like this possible?

AC16F - 3DF44


?? What should the result be for your example:

8C712E - 1A732S

 

[Ron Rosenfeld]

I need to calculate the difference between two alphanumeric cells. For example:

Column 1 Column 2
A16 A23 = 7

I have more complex alpha numeric strings such as:

Column 1 Column 2
1A732S 8C712E = ?

Any help would be appreciated

You will need to share with us the rules you are using to compute the
difference. Your examples do not make it clear
--ron