Reference left most value in cell

[rtwiss via OfficeKB.com]

How do i reference left most cell value?
IF(Left most cell value in A1 = Left most cell value in B1, true statement,
false statement)
Ex: A1= <45
I want function to locate "<"

 

[Sheeloo]

=IF(Left(A1,1)=Left(B1,1),"True","False")

 

[Bernard Liengme]

What do you mean by "left most cell value in A1" ?
A cell has only ONE value
best wishes

 

[Teethless mama]

Simplify version:

=LEFT(A1)=LEFT(B1)

=IF(Left(A1,1)=Left(B1,1),"True","False")