You seem to be saying that whether or not you find an MM in A2, you want the
contents of A2 putting into C2. Can yhou explain?

If you intended to say that if you find MM in A2 you want A2 copied to C2,
but otherwise you want *B2* into C2, then use
=IF(LEFT(A2,2)="MM",A2,B2)
--
David Biddulph

"Pammy" wrote in message
...
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.