2019-01-15
2019-01-15 本文已影响0人
沐沐jessica
Day26
【学员昵称】：沐沐
【学习内容】：10.8替换字符或字符串
【笔记分享】
1.删除补位的0值：=MID(SUBSITITUTE(B2,",0',","),+1(LEFT(B2)="0",99)
2.借助SUBSTITUTE函数提取会计科目：A.分列法，B.函数法=TRIM(MID(SUBSTITUTE($A2,"/",REPT("",99)),COLUMN(A1)*99-98,99)
3.借助SUBSTITUTE函数提取字符串=TRIM(RIGHT(SUBSTITUTE(A2,"-",REPT("",99)),99)
