if statement based on "starts with "
=ISNUMBER(MATCH("Next Day*",A2))+0
Todd F. wrote:
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
|