=MID(A1,FIND(CHAR(1),SUBSTITUTE(A1,"",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))+1,255)
这个公式的缺点是,如果句子只有一个单词...=IF(COUNTIF(A1,"**"),MID(A1,FIND(CHAR(1),SUBSTITUTE(A1,"",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"",""))))...或者:
=IF(LEN(A1)=LEN(SUBSTITUTE(A1,"","")),A1,MID(A1,FIND(CHAR(1),SUBSTITUTE(A1,"",CHAR(1),LEN(A1)-LEN...(SUBSTITUTE(A1," ",""))))+1,255))
使用LEN(A1)=LEN(SUBSTITUTE(A1," ","")判断是否有空格。...=TRIM(RIGHT(SUBSTITUTE(A1,"",REPT(" ",255)),255))