As you've most likely seen the distinction between this feature and solution #1 is always that, now, Excel notifies you that a macro has actually been disabled. This is the default possibility in Excel and, as described in Excel 2013 VBA and Macros , Excel authorities Mr. Excel (Bill Jelen) https://www.customguide.com/excel/concatenate-excel