EXCEL合并单元格保留数据

如图，让3列单元格合并成一个并保留内容

---

Sub join()
Dim cel As Range
Dim tmp As String

For Each cel In Selection
tmp = tmp & cel.Value
Next
With Selection
.Clear
.Merge
.Value = tmp
End With
End Sub

做个宏吧.选粗雀择你要合并的单元格,然后alt + f8 运行茄凳消颤知我给你的宏

子易空间站 - Excel培训专家

---

=B2&C2&E2

---