//替换一下成/ ，点到不能点为止
B1用公式：=SUBSTITUTE(TRIM(SUBSTITUTE(A1,"/"," "))," ","/")下拉。
=LEFT(A3,LARGE(IF(ISNUMBER(--MID(A3,ROW($1:$100),1)),ROW($1:$100),0),1))
