How to keep the text permanently after applying Concatenate function

[afatac]

I have joined two columns of text using

=CONCATENATE(H2,", ",I2)

Now, the J column has my desired result. How to delete column H and I and still keep the combined text in column J?

 

[mvptomlinson]

Select the cell in column J and choose Copy. Then right-click that cell and choose PasteSpecial, then Values.

You can then delete any of the cells that the formula was referring to.

 

[JoeMo]

Select all the cells with combined text. Right-click and choose Copy. Right-click again and choose paste special then Values. Now, delete the source columns.

 

[Abgar]

Simply select the column with the formula, and the Copy the date.

Right click in the same location, and select Paste Special, and then click on the "Values" button.

This will return the result of the formula only, as a standard text string.

You can then delete the other data without worries.

Cheers

 

[afatac]

Great! Thank you!