It sounds like you've merged the cells. Please don't.
--
David Biddulph

"Mark246" wrote in message
...
When I put this formula into cell N2, why does it occupy BOTH cells N2
and N3?

=IF(ISNUMBER(SEARCH(",",L2)),M2,L2)

Thanks

Mark246