| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove $ from formulas
Hi,
I have the following formula is about 200 cells and I need to remove all of the $ so that all cells are free to move when copied. Is there a way I czn remove them all at once rather than selecting each and doing it manually? Thanks =IF(COUNTIF($B$6:$B$48;$B53)=0;"";IF(SUMIF($B$6:$B $48;$B53;H$6:H$48)=0;"";SUMIF($B$6:$B$48;$B53;H$6: H$48))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove named ranges from formulas?? | Excel Discussion (Misc queries) | |||
| Remove Black line above Data which include formulas | Excel Discussion (Misc queries) | |||
| remove figures from a cell without removing the formulas | Excel Worksheet Functions | |||
| Remove a particular character using formulas | Excel Discussion (Misc queries) | |||
| remove formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
