Copying result of formula

Originally Posted by mrstuck

I have a formula that returns a string using the concatenate function. Now I want to copy the string to another cell without copying the formula. The string will become a record in a CSV file. I cannot figure out how to make what shows on the screen a label cell instead of a formula cell.

Thanks very much. Had tried that command but didn't do it correctly.