| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing Two Items Together-Urgent
I have copied a set of formulas from the last months' statement, referring to
two different sheets to a new workbook. The problem is that I cant replace both links in the formulas by ctrl+h, and the results is that "The formula is too long". Any idea how to replace two different items together, with two different items? Thanx! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Replacing Two Items Together-Urgent
Maybe you can make the references to the other worksheets shorter--open the
workbooks so that the paths are removed from the formulas. Change the worksheet name to something shorter may help, too. FARAZ QURESHI wrote: I have copied a set of formulas from the last months' statement, referring to two different sheets to a new workbook. The problem is that I cant replace both links in the formulas by ctrl+h, and the results is that "The formula is too long". Any idea how to replace two different items together, with two different items? Thanx! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| Replacing list title with list components - urgent! | Excel Worksheet Functions | |||
| Replacing Colored Items with Tags | Excel Worksheet Functions | |||
| Help with replacing items within a cell | Excel Worksheet Functions | |||
| named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Linear Mode
