>">" Logic Question

Hi willwonka​,

Below formula is used to separate each character of cell A2 (I have applied it in cell C2).

=MID(A2, SEQUENCE(MAX(LEN(A2))), 1)

To find TRUE or FALSE and to distinguish of English alphabets and numeric digits use below formula (I have applied it in cell D2).

=C2# > ">"

So now, due to the use of the ">" symbol, we have the results TRUE or FALSE.

In Excel, when you use the ">" operator to compare two values, it does not check whether they are letters or numbers, but makes a comparison according to the order of the characters in the ASCII (or Unicode) code.

Letters and numbers have ASCII codes ordered sequentially. For example:

"A" has the code 65

"B" has the code 66

So, when Excel compares "B" > "A", it returns TRUE because 66 is greater than 65.

In this case, ">" has the code 62. So if any given text has a code greater than 62 then this is counted as TRUE, otherwise FALSE.

Unicode collation depends on the lexicographical order set by Windows based on the selected locale / language. If Windows is in English then the Unicode Collation Algorithm (UCA) is used and in this case @ is positioned before the letters of the English alphabet and numbers as well.

So basically the process has to do with the Unicode ordering of different characters.

Have a nice day.

IlirU