|
我写了个整形链接的公式,但是每次要选择的指定项目特别长,所以想请教一下有没有方法使公式变简洁些?!
=LEFT(MID(LEFT(E230,MIN(IFERROR(FIND({"/index","#","?",".html"},E230),4^8))-1),FIND("ibm",LEFT(E230,MIN(IFERROR(FIND({"/index","#","?",".html"},E230),4^8))-1)),4^8),LEN(MID(LEFT(E230,MIN(IFERROR(FIND({"/index","#","?",".html"},E230),4^8))-1),FIND("ibm",LEFT(E230,MIN(IFERROR(FIND({"/index","#","?",".html"},E230),4^8))-1)),4^8))-ISNUMBER(FIND(RIGHT(MID(LEFT(E230,MIN(IFERROR(FIND({"/index","#","?",".html"},E230),4^8))-1),FIND("ibm",LEFT(E230,MIN(IFERROR(FIND({"/index","#","?",".html"},E230),4^8))-1)),4^8)),"/")))
以下部分必须跟着每个新的条件而重复出现多次,有没有方法把它简化呢!?
LEFT(E230,MIN(IFERROR(FIND({"/index","#","?",".html"},E230),4^8))-1))
|
|