Copy your column of concatenated data and then use a paste special with the
option of values selected to paste it back down your Concatenated column.
This will create your column as you like without formula based on the other
3 columns. You can then delete the other 3 columns.

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