Excel - Wrap Every Formula in a New Formula - Episode 1705
1,676 views · Published 8 May 2013 · 3:58 · Indexed 10 November 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: How to Wrap Every Formula in a New Formula in Excel | MrExcel Podcast. Welcome to the MrExcel podcast, sponsored by Easy Excel. In this episode, we will be discussing a useful Excel tip - how to wrap every formula in a new formula. This question was brought up by Tory during a seminar in Perrysburg, Ohio, and it got me thinking about different ways to achieve this task. Tory's question was how to select a range of cells with various formulas and wrap a new function around all of them. For example, adding the ROUND function after the equal sign and a comma with a value of zero at the end. My initial suggestion was to use the Find and Replace feature to change all equal signs to a carrot equal sign, which would make the formulas not function anymore. Then, we could make the necessary changes and revert the carrot equal signs back to equal signs. However, this method could be risky if there were other right parentheses in the range. Another approach is to use VBA. By inserting a tiny macro, we can easily add the ROUND function to each cell in the selection. The macro starts by assigning the old formula to a variable, then creating a new formula with the ROUND function and the old formula as its argument. The MID function in VBA is used to remove the equal sign at the beginning of the formula. Finally, the new formula is assigned to the cell's formula property. This method can be modified to add any desired wrapper function to the formulas in a range. If you have a better idea on how to wrap every formula in a new formula, please leave a comment on this video. It was Tory's question that sparked this discussion, and I would love to hear your thoughts and suggestions. This could also be a great opportunity to develop a useful add-in with error handling and other features. Thank you for watching this MrExcel netcast. I hope you found this tip helpful and will use it in your future Excel projects. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Wrapping formulas in a new function (00:14) Question from seminar attendee about selecting and wrapping formulas (00:24) Initial solution using find and replace (00:38) Potential issues with initial solution (01:00) Alternative solution using VBA (01:58) Explanation of VBA code (02:33) Running the VBA macro (03:03) Adding a different function using VBA (03:22) Request for alternative solutions from viewers (03:38) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Add round function to formulas Adding functions to formulas using VBA Easy Excel sponsorship Excel formulas Excel tutorial MrExcel net cast MrExcel podcast Proper function in Excel Replace equal sign with caret equal sign VBA macro Wrap formulas in new function Wrapper function for formulas Bill was conducting a seminar yesterday and was asked to wrap a Formula around existing Formulas. Today, in Episode #1705, Bill addresses this question and shows us what can be done to accomplish the task. ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs! Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1155083/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920