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

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

8 - 1?

712 - 732?

8712 - 1732?

In article ,
Jennifer Medina wrote:

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

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

"JE McGimpsey" wrote:

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

8 - 1?

712 - 732?

8712 - 1732?

In article ,
Jennifer Medina wrote:

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

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?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jennifer Medina" wrote in
message ...
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

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



In article ,
Jennifer Medina wrote:

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

"JE McGimpsey" wrote:

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

8 - 1?

712 - 732?

8712 - 1732?

In article ,
Jennifer Medina wrote:

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

On Mon, 3 Dec 2007 13:54:08 -0800, Jennifer Medina
wrote:

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