You can hide the columns that contain the data used in your concatenate
function:
Format Column Width then enter 0

Alternatively, copy and paste special (to a new column) the concatenate
function:
Edit Copy then select a new column Edit Paste Special Values


Regards,
Ryan---


--
RyGuy


"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!