EXCEL用函数从一行内容中提取数字、字母、符号

如果都是2个空格来区分的话
假设数据在A1
B1=LEFT(A1,FIND(" ",A1)-1)
C1=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,LEN(A1)-FIND(" ",A1))-FIND(" ",A1)-1)
D1=RIGHT(A1,LEN(A1)-FIND(" ",A1,LEN(A1)-FIND(" ",A1)))