excel 替换 空格字符后面的所有字符
=TRIM(REPLACE(A1,FIND(" ",A1),999,))
=TRIM(REPLACE(A1,1,FIND(" ",A1),))
=TRIM(MID(A1,FIND(" ",A1),99))
=MID(A1,FIND("*",SUBSTITUTE(A1," ","*")),99)
excel截取第一个空格前的字符
原文：https://www.cnblogs.com/zeenzhou/p/12103728.html
