compare alpha numeric

[G2K]

Hi,

I have some data in alfanumeric form which i need to compare.

DF4
DF14
DF15

AG12
AG15
AG5

is there any way to compare alphanumeric in excel or any method to extract number from given value and compare

Thanks

 

[mikerickson]

There are standard string comparison operators <, <= , =, >, >=

What kind of comparison are you looking for?

 

[G2K]

it compares data on alphabates where as i am looking for numeric compare of given data i.e A14 is greater than Z13

i want to comapre the numeric field only

 

[mikerickson]

Is the non-numeric prefix always 2 digits?

if so, =(MID(A1,3,100)+0)<(MID(B1,3,100)+0) should compare the numeric parts of A1 and B1.

 

[G2K]

thanks for your quick reply

but, if the data format is like one alphabet and 1 numeric like A9
then this formula will extract null

is there any method to fix this problem.