save concat values

Copper Contributor

I've combined column a and column b with concat formula in column c. I now want to just have the resulting value be static with the result of the formula so that I can delete columns a and b. Is this possible?

2 Replies

@thibsheltyz , if only copy column C and paste it as value on the same place

@Sergei BaklanI did try and it didn't work. Then I tried "paste special" " values" and that did it! Thanks!