View Single Post
  #1   Report Post  
Todd F.
 
Posts: n/a
Default if statement based on "starts with "

Can you build an if statement in excel that is driven by "starts with"

I have a filed that contains several text statements defining service level.

I have 3 that start with "Next Day" & end with "Drive"
"Over
night AM"
"Over
night PM"
I want the cel with the if statement to say soemthing simple like if it
starts with Next Day place a 1 here, etc.

Is there such a thing as starts with or contains in excel

Thanks for your time