Hello,

I am stuck and cannot remember how to do this...

I would like to perform an if statement that:

if (the current cell has a "C" character somewhere within it) then
........Perform an action......
elseif (it does not) then
..........perform another action.......
endif

What statement do I need to use to determine if a "C" is a character
anywhere in the cell. I remember how to use the Left, Right and Mid
functions, but I cannot remember how to use the Search function in this
manner. What would be the best way to go about doing this?

Thank You,