公式为:
=IFERROR(LEFT(A2,FIND("/",A2)-1),"无可用数据!")
如图所示:
=IF(A2="","",LEFT(A2,FIND("/",A2)-1))=IF(A2="","",RIGHT(A2,LEN(A2)-FIND("/",A2)))