Hello!



I have combined the data from five columns into one column using:

=CONCATENATE(H2,I2,J2,K2,L2)

Now I want to copy the resulting data into a new column. After it is copied into the new column, I want to delete the five columns and the concatenate column, so I'm just left with the results.

Could someone explain how to go about doing this?

Thank you!

Perhaps Copy - Paste special - Values

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you very much! That was easy and did the trick. (I'm still new to Excel!)