Apr 17 2019 06:50 AM - edited Apr 17 2019 06:50 AM
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?
Apr 17 2019 11:23 AM
@thibsheltyz , if only copy column C and paste it as value on the same place
Apr 17 2019 05:30 PM - edited Apr 17 2019 05:46 PM
@Sergei BaklanI did try and it didn't work. Then I tried "paste special" " values" and that did it! Thanks!