楼主
99253415 |
Q:如何将单元格内字符倒序排列？
如图所示
A:
方法一：自定义函数- Function reverse(a As Range)
- reverse = StrReverse(a.Value)
- End Function
方法二：基础操作
灵活运用内容重排，转置粘贴，辅助排序，剪贴板，查找替换等功能
2003版操作动画
2010版操作动画
操作步骤:
方法三：函数公式(冗长且局限)
- =MID(A1,45,1)&MID(A1,44,1)&MID(A1,43,1)&MID(A1,42,1)&MID(A1,41,1)&MID(A1,40,1)&MID(A1,39,1)&MID(A1,38,1)&MID(A1,37,1)&MID(A1,36,1)&MID(A1,35,1)&MID(A1,34,1)&MID(A1,33,1)&MID(A1,32,1)&MID(A1,31,1)&MID(A1,30,1)&MID(A1,29,1)&MID(A1,28,1)&MID(A1,27,1)&MID(A1,26,1)&MID(A1,25,1)&MID(A1,24,1)&MID(A1,23,1)&MID(A1,22,1)&MID(A1,21,1)&MID(A1,20,1)&MID(A1,19,1)&MID(A1,18,1)&MID(A1,17,1)&MID(A1,16,1)&MID(A1,15,1)&MID(A1,14,1)&MID(A1,13,1)&MID(A1,12,1)&MID(A1,11,1)&MID(A1,10,1)&MID(A1,9,1)&MID(A1,8,1)&MID(A1,7,1)&MID(A1,6,1)&MID(A1,5,1)&MID(A1,4,1)&MID(A1,3,1)&MID(A1,2,1)&MID(A1,1,1)
- =INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,18)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,17)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,16)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,15)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,14)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,13)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,12)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,11)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,10)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,9)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,8)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,7)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,6)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,5)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,4)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,3)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,2)&INDEX(MID(A1,COLUMN(INDIRECT("1:"&LEN(A1))),1),0,1)
 字符倒序-99253415.rar
|
