Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel
|
|||
|
|||
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. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add the actual value in a cell that contains a formula | Excel Discussion (Misc queries) | |||
Changing Cell contents from formula to the actual result | Excel Discussion (Misc queries) | |||
Switching Between Showing Formula Or Actual Result In A Cell ? | New Users to Excel | |||
how to get formula content of a cell? | Excel Worksheet Functions | |||
Cell content / formula bar different | Excel Discussion (Misc queries) |