View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Validation of partial data in a cell.

I would like to know how I can perform an IF statement on a cell when looking
at just the first few characters in that cell. Any suggestions?

i.e. Cell A1 = "Test"

If(A1={first two characters},1,0)

Thanks in advance, Chris.