Contain Function?

Hadrien Dykiel

I'd like to use an IF statement to accomplish the following:

 

If cell contains the character "?", then print "&" in the cell next to it.

 

I can't find any function that accomplishes what CONTAINS does in Excel, does anyone know a way to to do this?

John Sauber

Assuming the column name you're testing is called "Column 1", then the formula in "the column next to it" as you put it, is:

 

=IF(FIND("?", [Column 1]1) > 0, "&", "")

 

You have to decide what to put if there isn't a question mark. in this example, I'm making the cell blank.

Tamara K

Thanks John!

I tried using your formula to search in a single cell and it works. However, if I search within a range of cells and it's bringing up an error. Is there a trick for this?

Patty Rechberger

"I tried using your formula to search in a single cell and it works. However, if I search within a range of cells and it's bringing up an error. Is there a trick for this?"

 

I have the same problem.

Kirstine

I found this really helpful, thanks! (Luckily I didn't need to search a range...!)