excel中=C1&(RIGHt(LEFt(A1,LEN(A1)))) C1为空白单元格想反转A1单元格中的字符串要怎么做？
答案:1 悬赏:80 手机版
解决时间 2021-01-08 21:09
- 提问者网友：未信
- 2021-01-08 08:10
excel中=C1&(RIGHt(LEFt(A1,LEN(A1)))) C1为空白单元格想反转A1单元格中的字符串要怎么做？
最佳答案
- 五星知识达人网友：冷風如刀
- 2021-01-08 08:47
可以用VBA
将以下的程序复制到模块中，然后再写公式 =fanzhuan(a1) 就行了
Public Function fanzhuan(source As String)
Dim arr1(10000) As String, str1 As String, i As Integer, len1 As Integer
len1 = Len(source)
For i = len1 To 1 Step -1
arr1(len1 - i + 1) = Mid(source, i, 1)
Next i
fanzhuan = ""
For i = 1 To len1
fanzhuan = fanzhuan & arr1(i)
Next i
End Function
将以下的程序复制到模块中，然后再写公式 =fanzhuan(a1) 就行了
Public Function fanzhuan(source As String)
Dim arr1(10000) As String, str1 As String, i As Integer, len1 As Integer
len1 = Len(source)
For i = len1 To 1 Step -1
arr1(len1 - i + 1) = Mid(source, i, 1)
Next i
fanzhuan = ""
For i = 1 To len1
fanzhuan = fanzhuan & arr1(i)
Next i
End Function
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯