|
发表于 2013-10-7 01:52
|
显示全部楼层
本楼为最佳答案
适合任意长度文本的,你看看行不
黄色单元格(C6)- =IF(MIN(IF(ROW(INDIRECT("1:"&LEN(C4)))-1-MID(C4,ROW(INDIRECT("1:"&LEN(C4))),1)=-4,ROW(INDIRECT("1:"&LEN(C4)))))=0,"",--MID(C4,MIN(IF(ROW(INDIRECT("1:"&LEN(C4)))-1-MID(C4,ROW(INDIRECT("1:"&LEN(C4))),1)=-4,ROW(INDIRECT("1:"&LEN(C4))))),1))
复制代码 蓝色单元格(D6)- =IF(MAX(IF(ROW(INDIRECT("1:"&LEN(C4)))-1-MID(C4,LEN(C4)+1-ROW(INDIRECT("1:"&LEN(C4))),1)=-4,LEN(C4)+1-ROW(INDIRECT("1:"&LEN(C4)))))=0,"",--MID(C4,MAX(IF(ROW(INDIRECT("1:"&LEN(C4)))-1-MID(C4,LEN(C4)+1-ROW(INDIRECT("1:"&LEN(C4))),1)=-4,LEN(C4)+1-ROW(INDIRECT("1:"&LEN(C4))))),1))
复制代码 |
|