Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a model that someone made with TONS of round functions, which I have
no use for, since they muddy the formulas, which are already long, and I can get the effect by just formatting properly. How can I delete the function, while preserving what's inside? Each occurence has different characters inside, so I don't know how to find/replace, since my solution would be to find "round(" and replace with space, then move to last parentheses, but this will not only give an error once it tries to finish the first find/replace (it would have an ending paren with no beginning), but also potentially take out the ending parentheses for other expressions. Any way to get around this? There are hundreds of occurences, so any avoidance of manual change would be great. -- Boris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
how do i set up round function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) |