黄色为范围(数据源)
我要的结果在B1单元(合并黑色的字符)
在我的结果里第一个字符为"出"字,后合才是合并的字符串
Sub ss()
Dim c As Range
s = "åº"
For Each c In [b5:c6]
For i = 2 To Len(c)
If Characters(i, 1).Font.ColorIndex = xlAutomatic Then
s = s & Mid(c, i, 1)
End If
Next
Next
[b1] = s
End Sub追é®
Dim c As Range
s = "åº"
For Each c In [b5:c6]
For i = 2 To Len(c)
If c.Characters(i, 1).Font.ColorIndex = xlAutomatic Then
s = s & Mid(c, i, 1)
End If
Next
Next
[b1] = s
End Sub追é®
Dim c As Range
s = "åº"
For Each c In [b5:c6]
For i = 2 To Len(c)
If Characters(i, 1).Font.ColorIndex = xlAutomatic Then
s = s & Mid(c, i, 1)
End If
Next
Next
[b1] = s
End Sub追é®
If Charactersåè¿ç¨æªå®ä¹
追çSub ss()Dim c As Range
s = "åº"
For Each c In [b5:c6]
For i = 2 To Len(c)
If c.Characters(i, 1).Font.ColorIndex = xlAutomatic Then
s = s & Mid(c, i, 1)
End If
Next
Next
[b1] = s
End Sub追é®
For i = 2 To Lenè¿ä¸ªæ¯ä»ä¹ææ
追ç第ä¸ä¸ªåæ¯åºä¸ç®ä»ç¬¬äºä¸ªå°æåä¸ä¸ªä¸ä¸ªä¸ä¸ªæ¥ç
温馨提示:答案为网友推荐,仅供参考