Automate removal of ROUND from formulas

[Lis7]

I have a large number of formulas of the type below. "blahblahblah" is different for each formula and I want to preserve that part of each formula.

=ROUND(SUMIFS(blahblahblah),1)

Need to remove "ROUND(" and ",1)" and leave the rest of the formula intact. Wildcarding doesn't seem to work in Excel 2007 for the Replace functionality. Any ideas? I don't know VB, I do know how to run a macro (may need some pointers on how to install it though).

Thanks.

[Jakobshavn]

This could be easily done with a macro.

Please Login or Register  to view this content.

Macros are very easy to install and use:

1. ALT-F11 brings up the VBE window
2. ALT-I

ALT-M opens a fresh module

3. paste the stuff in and close the VBE window

If you save the workbook, the macro will be saved with it.

To use the macro from the normal Excel window:

1. ALT-F8
2. Select the macro
3. Touch Run



To remove the macro:

1. bring up the VBE window as above
2. clear the code out
3. close the VBE window

To learn more about macros in general, see:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

[Lis7]

Jakob, one follow-up question - how would I run this on selected columns?

[Jakobshavn]

This restricts the macro to act only on column D:

Please Login or Register  to view this content.