I have 2 columns (A and B) and in column C, I want a formula that will look
at Column A and in each cell and where it finds an MM....... I want this
moved to column C, but if it does not find an MM, I want what ever is in the
cell of A column moved over to C.
I have used:

=IF(LEFT(A2,2)="MM",A2)
but it brings back a false in column C if it doesn't find an MM.