Excel 提取文本中数字公式

[[{"txt": "\u7ecf\u5e38\u9047\u5230\u8f93\u5165\u6570\u503c\u5e26\u6709\u4e2d\u6587\u5728\u524d\u9762\u6216\u8005\u540e\u9762\uff0c\u4f46\u662f\u5374\u9700\u8981\u7528\u6570\u503c\u6765\u8ba1\u7b97\u3002\u600e\u4e48\u63d0\u53d6\u8fd9\u4e9b\u4e2a\u6570\u5b57\u5462\uff1f"}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "Excel"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u7b2c\u4e00\u79cd\uff0c\u5982\u56fe\uff0c\u5982\u679c\u6570\u5b57\u5728\u4e2d\u6587\u7684\u540e\u9762\uff0c\u90a3\u4e48\u4f7f\u7528\u516c\u5f0f\uff1a\"=--RIGHT(A2,LEN(A2)*2-LENB(A2))\"\u89e3\u91ca\u4e0b\uff1a\u56e0\u4e3a\u4e2d\u6587\u5b57\u7b26\u662f\u5360\u4e24\u4e2a\u5b57\u8282\u3002\u800c\u6570\u5b57\u5360\u4e00\u4e2a\u5b57\u8282\u3002len\u8fd4\u56de\u503c\u662f\u5b57\u7b26\u7684\u4e2a\u6570\u3002\u800clenb\u8fd4\u56de\u503c\u662f\u8fd9\u4e2a\u5b57\u7b26\u4e32\u5360\u591a\u5c11\u4e2a\u5b57\u8282\u3002\u6240\u4ee5\uff0c\u8fd9\u4e24\u4e2a\u7684\u5dee\u503c\u5c31\u662f\u4e00\u4e2a\u6709\u51e0\u4e2a\u4e2d\u6587\u3002LENB(A2)-LEN(A2) = \u4e2d\u6587\u5b9e\u9645\u4e2a\u6570\u5b57\u7b26\u603b\u6570-\u4e2d\u6587\u4e2a\u6570=\u6570\u5b57\u4e2a\u6570LEN(A2)-\uff08LENB(A2)-LEN(A2)\u00a0\uff09=\u6570\u5b57\u4e2a\u6570\u5f00\u62ec\u53f7 \u6570\u5b57\u4e2a\u6570=LEN(A2)*2-LENB(A2)\u3002\u56e0\u4e3a\u6570\u5b57\u5728\u53f3\u8fb9\uff0c\u6240\u4ee5\uff0c\u5229\u7528RIGHT\uff0c\u83b7\u53d6\u4ece\u53f3\u8fb9\u7b2c\u4e00\u4e2a\u5f00\u59cb\u5230\u6700\u540e\u4e00\u4e2a\u6570\u5b57\uff0c\u5c31\u5f97\u5230\u8fd9\u4e2a\u6570\u503c\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/0d55dc7bd282868992b49b0565f97fbd4d7c374a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u4e8c\u79cd\uff1a\u6570\u5b57\u5728\u4e2d\u6587\u7684\u524d\u9762\u3002\u5b9e\u9645\u4e0a\u548c\u7b2c\u4e00\u79cd\u7684\u65b9\u6cd5\u662f\u4e00\u6837\u7684\uff0c\u8fd9\u513f\u53ea\u662f\u53d6\u6570\u5b57\u7684\u65f6\u5019\uff0c\u4ece\u5de6\u8fb9\u5f00\u59cb\u3002\u516c\u5f0f\uff1a \"=--LEFT(A2,LEN(A2)*2-LENB(A2))\""}, {"img": ["https://exp-picture.cdn.bcebos.com/7efc527c34b33c410948fff5887de137c8762e4a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u7b2c\u4e09\u79cd\uff1a\u6df7\u642d\u3002\u8fd9\u4e2a\u5176\u5b9e\u5c31\u662f\u52a0\u4e2a\u5224\u65ad\uff0c\u5224\u65ad\u7b2c\u4e00\u4e2a\u5b57\u7b26\u662f\u6570\u5b57\u8fd8\u662f\u4e2d\u6587\u3002\u5982\u679c\u662f\u6570\u5b57\uff0c\u90a3\u4e48\u5c31\u7528\u4e0a\u9762\u7684\u7b2c\u4e8c\u4e2a\u516c\u5f0f\uff0c\u4e2d\u6587\u5c31\u7528\u7b2c\u4e00\u4e2a\u516c\u5f0f\u3002\u516c\u5f0f\uff1a\u201c=IF(ISNUMBER(--LEFT(A2,1)),--RIGHT(A2,LEN(A2)*2-LENB(A2)),--LEFT(A2,LEN(A2)*2-LENB(A2)))\u201d"}, {"img": ["https://exp-picture.cdn.bcebos.com/23fd63c5cf672b5f96b429223314f4d0b403274a.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}]]