Copying result of formula

**mrstuck** · 09-10-2009, 12:18 PM

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.

**NBVC** · 09-10-2009, 12:20 PM

go to the cell you want to copy to and then go to Edit|PAste Special and select Values...

click Ok..

**vorabha** · 09-10-2009, 12:21 PM

it should ne Copy > Past special Value

if not
can you be more specific to your Q ? or attach a explample sheet

**mrstuck** · 09-10-2009, 12:56 PM

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.