excel截取第一个空格前的字符

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)