A1 入左一個名叫
CHAN TAI MAN PETER.
我只想要 PETER CHAN.
EXCEL有無FUNCTION 可以CUT出黎
cut 某一d 字
2010-09-02 2:31 am
回答 (3)
2010-09-02 6:00 pm
✔ 最佳答案
此題方法, 並非 CUT 某D字, 而是取某D字先取最右一個字 PETER
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))
再取最左的一個字 CHAN
LEFT(A1,FIND(" ",A1)-1
將公式合併:
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))&" "&LEFT(A1,FIND(" ",A1)-1)
出 PETER CHAN
2010-09-03 9:55 pm
This one can solve the word length greater than 99.
=TRIM(RIGHT(SUBSTITUTE(A3," ",REPT(" ",LEN(A1))),LEN(A1)))&" "&LEFT(A3,FIND(" ",A3)-1)
=TRIM(RIGHT(SUBSTITUTE(A3," ",REPT(" ",LEN(A1))),LEN(A1)))&" "&LEFT(A3,FIND(" ",A3)-1)
2010-09-02 5:26 pm
下面的公式, 可以完成任務.
=RIGHT(A1,LEN(A1)-IF(ISERR(FIND(" ",A1,FIND(" ", A1, FIND(" ",A1)+1)+1)), FIND(" ", A1, FIND(" ",A1)+1), FIND(" ",A1,FIND(" ", A1, FIND(" ",A1)+1)+1))) & " " & LEFT(A1,FIND(" ",A1)-1)
注意: 上述公式是假設英文名字是由 3 或4 個英文字組成.
=RIGHT(A1,LEN(A1)-IF(ISERR(FIND(" ",A1,FIND(" ", A1, FIND(" ",A1)+1)+1)), FIND(" ", A1, FIND(" ",A1)+1), FIND(" ",A1,FIND(" ", A1, FIND(" ",A1)+1)+1))) & " " & LEFT(A1,FIND(" ",A1)-1)
注意: 上述公式是假設英文名字是由 3 或4 個英文字組成.
收錄日期: 2021-04-13 17:28:56
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20100901000051KK01136