Copy the merged cells and select paste special - values. Now you can delete
the 3 original columns...
--
HTH...

Jim Thomlinson


"Bird Byte" wrote:

I've successfully merged data in 3 adjacent cells into a new cell, and
repeated the formula for all the records. The problem is, I need to delete
the original columns, but when I do, the reference is lost for the new column
and the data disappears. How can I change the merged cell values to be
literal instead of referenced? Is there a better way to approach this besides
merge?

Thanks very much for any ideas.