Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge formulas from 2 cells into one formula in one cell
In Excel versions 2003 and earlier I use to be able to use paste special-
Formulas- Add to combine formulas from two different cells into the same cell. It doesn't work in Excel 2007. Any idea if there is a setting or such that I am missing that will give me this functionality back? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge formulas from 2 cells into one formula in one cell
Hi,
Unfortunately this no longer works in 2007. It is a known bug (feature?) and has been reported to Microsoft. -- If this helps, please click the Yes button Cheers, Shane Devenshire "ExcelGeek" wrote: In Excel versions 2003 and earlier I use to be able to use paste special- Formulas- Add to combine formulas from two different cells into the same cell. It doesn't work in Excel 2007. Any idea if there is a setting or such that I am missing that will give me this functionality back?Hi |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge formulas from 2 cells into one formula in one cell
Shane,
This is a MAJOR oversite on Microsoft's part. I just got upgraded to Office 2007 at work and had I known this was a problem I would have resisted the upgrade. My job is building complex analysis tools for others to use and I would frequently build up complex formulas in blocks and use Paste Special Formulas Add(Subrtact, Multiply or Divide) to merge the blocks. The one formula to another is not so much the problem as the one array of formulas to another. I will have to change the way I design models to accommodate something that should have been an easy design from the beginning. If you know any way I can express my displeasure to the yahoos on the Office team, please advise. Thanks "Shane Devenshire" wrote: Hi, Unfortunately this no longer works in 2007. It is a known bug (feature?) and has been reported to Microsoft. -- If this helps, please click the Yes button Cheers, Shane Devenshire "ExcelGeek" wrote: In Excel versions 2003 and earlier I use to be able to use paste special- Formulas- Add to combine formulas from two different cells into the same cell. It doesn't work in Excel 2007. Any idea if there is a setting or such that I am missing that will give me this functionality back?Hi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge cells with formula or macro? | Excel Discussion (Misc queries) | |||
How can I merge 3 cells into 1 cell? | Excel Worksheet Functions | |||
how to merge many cells to one cell with keeping all data | Excel Worksheet Functions | |||
merge several cells with text into 1 cell | Excel Discussion (Misc queries) | |||
How do I merge one cell into two cells? | Excel Discussion (Misc queries) |