I previously copied the following formula from the site (don't remember who
originally contributed it,) and I modified it slightly to get rid of Upper
and subtracting 33. Note: this is far from perfect, but I doubt there is a
perfect solution to your request.

=SUMPRODUCT(CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1)) ),1)))

TomBill 691
BillTom 691
FrankJohn 897
JohnFrank 897
DAD 201
BEB 201


--
Kevin Vaughn


"MaxNY23" wrote:

In column A and B I have text representing an Entity and its Intercompany,
respectively. In column C I have concatenated the two. So now in Column C,
for example, I have "BillTom" in row 1 and "TomBill" in row 900.

I need Excel to convert the text into some sort of code, ASCII or number
that shows they are EQUAL. I need something that shows "TomBill" and
"BillTom" are the same thing, just in a different order.

I cannot build an IF formula or use Find/Replace, as I will have thousands
of these types of combinations.

Thanks!