Comparing a number without dimensional units with one that has dimensional units?

[InOverMyH3ad]

Scenario:

Cell A: 12
Cell B: 12" (or even 12 in.)

Cell A will never have units. It will always be cell B that will be the issue. I'm trying to figure out a way to be able to compare the two cells and determine if they are equal or what the difference between them us. The issue is getting excel to ignore the units after the numbers. Is this possible in some sort of non-VB way?

 

[Cubist]

The formula in #10 won't work if there are repeating numbers, redo:

Book1
	A	B
1
2	12"	12
3	12 in	12
4	12.5 in	12.5
5	16.584 in	16.584
6	16.5821 "	16.5821
7	It's 3.5 inches long	3.5
8	111"	111
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=LET(x,XMATCH(TRUE,ISNUMBER(--MID(A2,SEQUENCE(LEN(A2)),1)),,{1;-1}),--MID(A2,MIN(x),MAX(x)-MIN(x)+1))