Assuming D1 has:
=A1 & B1 & C1
then copy column D and paste/special/value back onto itself. Then columns
A, B, and C can be deleted.
--
Gary''s Student - gsnu200776


"DianaL" wrote:

I used the concatenate function to combine columns of Last Name, First Name,
Middle Initial. Now, I want that combined information to remain and I want
to delete the three separate columns. How can I do that without losing the
concatenate function? Thanks!