Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting rows based on IF statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Msgbox based on If statement | Excel Worksheet Functions | |||
IF statement based on data type | Excel Worksheet Functions | |||
Conditional formatting based on if statement. | Excel Worksheet Functions |