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?
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.
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?
"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.
I found this really helpful, thanks! (Luckily I didn't need to search a range...!)
