截取一串数字中某个数字、几个数字的方法

[[{"txt": "\u7528excel\u4e2d\u7684\u51fd\u6570\u622a\u53d6\u4e00\u4e32\u6570\u5b57\u4e2d\u7684\u67d0\u4e2a\u6570\u5b57\u3001\u51e0\u4e2a\u6570\u5b57\uff0c\u9700\u8981\u7528\u5230\u662f\u622a\u53d6\u5b57\u7b26\u4e32\u51fd\u6570\uff0c\u800c\u5982\u679c\u9700\u8981\u5c06\u8fd9\u4e9b\u622a\u53d6\u7684\u5b57\u7b26\u4e32\u5408\u5e76\u8d77\u6765\uff0c\u53c8\u9700\u8981\u7528\u5230\u6587\u672c\u5408\u5e76\u51fd\u6570\u3002\u4e0b\u9762\u4ee5\u8eab\u4efd\u8bc1\u4e3a\u4f8b\uff0c\u622a\u53d6\u51fa\u751f\u5e74\u3001\u6708\u3001\u65e5\uff0c\u5e76\u5c06\u622a\u53d6\u7684\u5e74\u6708\u65e5\u5408\u5e76\u5728\u4e00\u8d77\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/4080a927ac5306885c97947957e8904801fc9612.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "\u7535\u8111"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u6253\u5f00\u9700\u8981\u622a\u53d6\u67d0\u90e8\u5206\u6570\u7684\u4e00\u4e32\u6570\u5b57\uff08\u8eab\u4efd\u8bc1\u53f7\uff09\uff0c\u4f8b\u5982\u4e0b\u56fe\u6240\u793a\uff0c\u7ea2\u8272\u90e8\u5206\u662f\u51fa\u751f\u5e74\u6708\u65e5\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/76b6860e5f20437189600793323acd8921c58f12.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9009\u4e2d\u7528\u4e8e\u5b58\u653e\u51fa\u751f\u5e74\u6708\u7684\u5355\u5143\u683c\uff0c\u4f7f\u7528MID\u51fd\u6570\u6765\u622a\u53d6\u51fa\u751f\u5e74\u3001\u6708\u3001\u65e5\u3002\u8f93\u5165\u201c=MID(A2,7,4),\"\u5e74\",MID(A2,11,2),\"\u6708\",MID(A2,13,2),\"\u65e5\"\u201d\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/274e9635dd8a59de9abcb9b2b370d5413b8c8412.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\u7528CONCATENATE\u51fd\u6570\u5c06\u5176\u5408\u5e76\u5230\u4e00\u8d77\uff0c\u6700\u7ec8\u7684\u516c\u5f0f\u201c=CONCATENATE\uff08MID(A2,7,4),\"\u5e74\",MID(A2,11,2),\"\u6708\",MID(A2,13,2),\"\u65e5\"\uff09\u201d\u201d\u6309\u4e0benter\u952e\uff0c\u622a\u53d6\u7684\u51fa\u751f\u5e74\u6708\u5982\u4e0b\u56fe\u6240\u793a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/a44e8afc508c9bce2e43bbc4d6dd884ce44afa12.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9f20\u6807\u653e\u5230B2\u5355\u5143\u683c\u53f3\u4e0b\u89d2\uff0c\u53d8\u6210\u5b9e\u5fc3\u5341\u5b57\u540e\u6309\u4f4f\u5411\u4e0b\u62d6\u52a8\u586b\u5145\u51fd\u6570\uff0c\u6240\u6709\u4eba\u7684\u51fa\u751f\u5e74\u6708\u90fd\u88ab\u622a\u53d6\u51fa\u6765\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e40b3127e7ef28069abaa36eb840b6f39087f212.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa42"]}, {"txt": "\u9009\u4e2d\u5b58\u653e\u51fa\u751f\u5e74\u6708\u7684\u5355\u5143\u683c\uff0c\u4f7f\u7528MID\u51fd\u6570\u6765\u622a\u53d6\u51fa\u751f\u5e74\u3001\u6708\u3001\u65e5\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/3201a8f39187031c6e7b9e4f6a86242fa972ec12.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7136\u540e\u4f7f\u7528&\uff0c\u5c06\u6570\u5b57\u8fde\u5728\u4e00\u8d77\u3002\u8f93\u5165\u201c=MID(A2,7,4)&\"\u5e74\"&MID(A2,11,2)&\"\u6708\"&MID(A2,13,2)&\"\u65e5\"\u201d\uff0c\u6309\u4e0benter\u952e\uff0c\u622a\u53d6\u7684\u51fa\u751f\u5e74\u6708\u5982\u4e0b\u56fe\u6240\u793a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/955ea0e434daf05e4a9f48c2751d96d81919e512.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9f20\u6807\u653e\u5230C2\u5355\u5143\u683c\u53f3\u4e0b\u89d2\uff0c\u53d8\u6210\u5b9e\u5fc3\u5341\u5b57\u540e\u6309\u4f4f\u5411\u4e0b\u62d6\u52a8\u586b\u5145\u51fd\u6570\uff0c\u6240\u6709\u4eba\u7684\u51fa\u751f\u5e74\u6708\u90fd\u88ab\u622a\u53d6\u51fa\u6765\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/6061b9cd0c6efbf20b0f4464127bbbf4db58da12.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]