Excel 常用的2个宏(拆分单元格并自动填充数据、取满足条件的值连接成字符串)
打开宏:查看宏 1.拆分单元格并自动填充数据Sub 拆分填充()'' 拆分填充 宏'' 快捷键: Ctrl+d'Dim x As RangeFor Each x In ActiveSheet.UsedRange.CellsIf x.MergeCells Thenx.Selectx.UnMergeSelection.Value =