excel提取指定文字后的内容答:公式一:=MID(A3,FIND("收货人:",A3)+4,FIND(",",A3)-5)公式二:=MID(A3,FIND("地址:",A3)+3,FIND("手机号",A3)-FIND("地址:",A3)-4)公式三:=MID(A3,FIND("手机号:",A3)+4,11)
Excel 快速提取固定文字后面的数字?答:B1输入 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"Pc10:",),"Pc30:",),"Pc50:",),"Rc10:",),"Rc30:",),"Rc50:",)下拉