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.