IF statement based on presence or absence of a specific character.

[Motox]

Hi Forum,

I want to set up an IF statement that determines if a specific character (“_”) is present in a part number and then returns a result accordingly.

Is there a function that can be used in an IF statement that works like “Contains’ when you do a filter?

It would work like:

=IF(A2 Contains “_”, “Yes”, “No”)

Is there a way to set up an IF statement to work like this?

Thanks very much

Dave

[HaHoBe]

Hi, Dave,

InStr will return the position of the first character of the search string in the original string (so if gretaer 0 there´s a match), and Like will compare the strings

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger

[mikerickson]

Try
=IF(ISNUMBER(FIND("_", A2)), "underscore present", "not")

[FDibbins]

Also note that in your sample you are using “_” while excel would be expecting "_" “” vs ""