摘要:
Extract substring in ExcelFunction: =MID(B1, FIND("<ns104:Nric",B1) + 51, FIND("</ns104:Nric",B1) - FIND("<ns104:Nric",B1) - 51)e.g. if B1 = <ns104:Nric xmlns:ns104="http://www.microsoft.com">12345678</ns104:Nric>Result:12345678Concatenate 阅读全文
posted @ 2012-03-16 15:20 zhaobin 阅读(233) 评论(0) 推荐(0) 编辑