If you look in the archives of this group you will see countless examples of
reasons not to use merged cells.
To concatenate cells is fine, to merge is asking for trouble.
--
David Biddulph


"Excel Ella" wrote in message
...
Can someone help me in developing a formula that will:
1. Count how many merged cells in a column that are created from 2 cells
AND contain both text and numbers?
2. Count how many merged cells in a column that are created from 3 cells
AND contain both text and numbers?
3. Council how may merged cells in a column that are blank.