Sorry for not being clear. In this case, merge as to format several cells to
appear as one cell.

"bj" wrote:

what do you mean by merging cells?
merging can mean anything from
summing up values.
Deleting duplicates,
to formatting several cells to appear as one cell.

"Joe M." wrote:

I would like to merge cells in column A when the adjacent vertical cells are
the same. For example:

Col A
Row1 CX457
Row2 AG925
Row3 AG925
Row4 AG925
Row5 RB639
Row6 RB639

In this case A2, A3 & A4 would be merged, A5 & A6 would be merged. Is there
a way to do this automatically?

Thanks,
Joe M.