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.

The formulas just to count cells with either text or numbers (or text AND
numbers) is bad enough, but I don't even know of a worksheet function that
can tell you:
1) if a cell is merged or not
2) how many cells are merged to make the one troublemaker

My advice is to go back and take the time to unmerge the cells and use
"center across selection" for the horizontal alignment of them across however
many columns are required. Merging of cells that will be used in
calculations or referenced in VB code = BAD.

"Excel Ella" wrote:

> 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.