View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Validation of partial data in a cell.

You mean like this?

=If(MID(A1,1,2)="Te",1,0)

Chris wrote:

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.