我是做淘宝的,刚找了个快递单打印软件,需要分离相关信息.请朋友们帮个忙看看.

自由飞翔的猪 · 发表于 2014-7-3 10:18

分离成我表格中所显示的就行.多谢各位大神.

dajiahaoxinku12 · 发表于 2014-7-3 10:24

数据，按短杠先分列一下然后再处理

wjxw · 发表于 2014-8-11 17:57

我也不会但我给找了个提取手机号码的公式

=LARGE(IF(ISNUMBER(--MID($A4&"a",ROW(INDIRECT("1:"&LEN($A4)+1)),11)),--MID($A4&"a",ROW(INDIRECT("1:"&LEN($A4)+1)),11)),COLUMN(A4))

dyx790106 · 发表于 2015-1-8 17:40

本帖最后由 dyx790106 于 2015-1-8 18:07 编辑

用户名=LEFT(A2,FIND("-",A2)-1)；地址==IF(LEN(SUBSTITUTE(MID(A2,FIND("记号",SUBSTITUTE(A2,"-","记号",LEN(A2)-LEN(SUBSTITUTE(A2,"-","")))),99),"-",REPT("",99)))<11,SUBSTITUTE(MID(A2,FIND("-",A2)+1,FIND("记号",SUBSTITUTE(A2,"-","记号",LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))-3))-4),"-",REPT("",99)),SUBSTITUTE(MID(A2,FIND("-",A2)+1,FIND("记号",SUBSTITUTE(A2,"-","记号",LEN(A2)-LEN(SUBSTITUTE(A2,"-",""))-1))-4),"-",REPT("",99)))
电话号码==IF(LEN(SUBSTITUTE(MID(A2,FIND("记号",SUBSTITUTE(A2,"-","记号",LEN(A2)-LEN(SUBSTITUTE(A2,"-","")))),99),"-",REPT("",99)))<11,(SUBSTITUTE(MID(A2,FIND("记号",SUBSTITUTE(A2,"-","记号",LEN(A2)-LEN(SUBSTITUTE(A2,"-","")))-1),99),"-",REPT("",99))),(SUBSTITUTE(MID(A2,FIND("记号",SUBSTITUTE(A2,"-","记号",LEN(A2)-LEN(SUBSTITUTE(A2,"-","")))),99),"-",REPT("",99))))
如果只有固定电话，无手机号地址会出错，

		自动登录	找回密码
密码			免费注册