excel合并单元格如何得到所有数据？并显示在原来的单元格中， 默认的 合并单元格只保留最左边的数据。
------解决方案--------------------------------------------------------
用VBA吧
- VB code
Sub MergeRanges() Dim rng As Range, txt As String For Each rng In Selection txt = txt & rng.Value2 Next Application.DisplayAlerts = False Selection.Merge Selection = txt Application.DisplayAlerts = TrueEnd Sub