Thread: Reference left most value in cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
  
Posts: 1,805
Default Reference left most value in cell
=IF(Left(A1,1)=Left(B1,1),"True","False")
--
Always provide your feedback...


"rtwiss via OfficeKB.com" wrote:

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 "<"

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200810/1


Reply With QuoteReply With Quote