Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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...!)
