(资料图片)
1、:如下图:取收货人公式:=SUBSTITUTE(LEFT(A3,FIND(",",A3,1)-1),"收货人:","")取地址公式:=SUBSTITUTE(MID(A3,FIND(",",A3)+1,FIND("*",SUBSTITUTE(A3,"。
2、","*",2))-FIND(",",A3)-1),"地址:","")取手机号公式:=SUBSTITUTE(RIGHT(A3,LEN(A3)-FIND("*",SUBSTITUTE(A3,",","*",2))),"手机号:","")。
相信通过excel中提取指定文字这篇文章能帮到你,在和好朋友分享的时候,也欢迎感兴趣小伙伴们一起来探讨。
本文由用户上传,如有侵权请联系删除!Copyright © 2015-2032 华西产业网版权所有 备案号:京ICP备2022016840号-35 联系邮箱: 920 891 263@qq.com