Turning value of formula into actual cell content?
 

Hi. I've a sheet with a few thousand rows where in column B I need to
add a prefix to every value.
What I did was in column M fill the cells with the prefix, and made
column N a copy of column B.
Then in Column B I made the function: =M2&""&N2 and copied it all the
way down (with incrementing numerals).
That works great. But, I need to be able to copy-n-paste the new
prefixed value of some of the cells in column B into another
spreadsheet. But when I try, what I'm copying is the formula, not the
resulting value.
Is there a way to copy the values generated by the formula and paste
them as the values?
Thanks,
Liam

Turning value of formula into actual cell content?
 

On Jun 26, 3:23*pm, Mechphisto wrote:
Hi. I've a sheet with a few thousand rows where in column B I need to
add a prefix to every value.
What I did was in column M fill the cells with the prefix, and made
column N a copy of column B.
Then in Column B I made the function: =M2&""&N2 and copied it all the
way down (with incrementing numerals).
That works great. But, I need to be able to copy-n-paste the new
prefixed value of some of the cells in column B into another
spreadsheet. But when I try, what I'm copying is the formula, not the
resulting value.
Is there a way to copy the values generated by the formula and paste
them as the values?
Thanks,
Liam

Oh, I think I figured it out. Although I could use any feedback of any
pitfalls or problems doing this:
I select and copy the column B with all the function generated values,
then I "paste special..." and select "Values" right on top of itself
and Bingo! When I click a cell in B, instead of seeing the formula in
the formula box up top, and now see just the value and can now copy-n-
paste that value wherever I want. :)