答:如下图:
取收货人公式:
=SUBSTITUTE(LEFT(A3,FIND(",",A3,1)-1),"收货人:","")
取地址公式:
=SUBSTITUTE(MID(A3,FIND(",",A3)+1,FIND("*",SUBSTITUTE(A3,",","*",2))-FIND(",",A3)-1),"地址:","")
取手机号公式:
=SUBSTITUTE(RIGHT(A3,LEN(A3)-FIND("*",SUBSTITUTE(A3,",","*",2))),"手机号:","")
本回答被网友采纳