EXCEL中如何将电话号码从文本单元格中提出

[[{"txt": "\u5f53\u4eba\u5458\u59d3\u540d\u548c\u7535\u8bdd\u53f7\u7801\u590d\u5408\u5728\u4e00\u4e2a\u5355\u5143\u6846\u4e2d\u65f6\uff0c\u7528\u6237\u5e38\u5e38\u9700\u8981\u5c06\u4e24\u9879\u5185\u5bb9\u5206\u5f00\u3002\u90a3\u4e48\uff0c\u5982\u4f55\u5c06\u7535\u8bdd\u53f7\u7801\u4ece\u5355\u5143\u683c\u4e2d\u5355\u72ec\u63d0\u53d6\u51fa\u5462\uff1f"}, {"img": ["https://exp-picture.cdn.bcebos.com/c255efc595ee41c1aa3472e08d88912ca4ca9baa.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u5de5\u5177/\u539f\u6599"]}, {"txt": "EXCEL"}], [{"txt": ["\u65b9\u6cd5/\u6b65\u9aa4"]}, {"txt": "\u5982\u4e0b\u56fe\uff0cA\u5217\u5217\u5f0f\u51fa\u7684\u201c\u4eba\u5458\u4fe1\u606f\u201d\u5305\u62ec\u4eba\u540d\u548c\u7535\u8bdd\u53f7\u7801\u3002\u672c\u4f8b\u8981\u6c42\u5c06\u7535\u8bdd\u53f7\u7801\u4eceA\u5217\u4fe1\u606f\u4e2d\u5355\u72ec\u63d0\u53d6\u51fa\u6765\uff0c\u7ed3\u679c\u5728B\u5217\u663e\u793a\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/906dbbcadce8904824efa944130e5f20427192aa.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9009\u4e2dB2\u5355\u5143\u683c\uff0c\u5728\u5355\u5143\u683c\u4e2d\u8f93\u5165\u8fd0\u7b97\u7b26\u53f7\u201c=\u201d\uff0c\u7136\u540e\u70b9\u51fb\u3010\u63d2\u5165\u51fd\u6570\u3011\u6309\u94ae\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/5e615d715fdb36209229133aabc5260f89358daa.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5f39\u51fa\u3010\u63d2\u5165\u51fd\u6570\u3011\u5bf9\u8bdd\u6846\uff1a\u5728\u201c\u6216\u9009\u62e9\u7c7b\u522b\u201d\u4e2d\u9009\u62e9\u201c\u5168\u90e8\u201d\u9009\u9879\uff1b\u5728\u201c\u9009\u62e9\u51fd\u6570\u201d\u4e2d\u9009\u62e9\u201cRIGHT\u201d\u51fd\u6570\uff0c\u8bbe\u7f6e\u597d\u540e\u70b9\u51fb\u3010\u786e\u5b9a\u3011\u6309\u94ae\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/ccc83ec5260f8835ed99876dce078801397086aa.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/dccb47de450788010c630bf2b18ca608a40f82aa.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u5f39\u51fa\u3010\u51fd\u6570\u53c2\u6570\u3011\u5bf9\u8bdd\u6846\uff1a\u5c06\u5149\u6807\u79fb\u52a8\u5230\u7b2c\u4e00\u4e2a\u53c2\u6570\u540e\u9762\u7684\u5bf9\u8bdd\u6846\u4e2d\uff0c\u9009\u4e2d\u8868\u683c\u4e2d\u7684A2\u5355\u5143\u683c\uff1b\u5c06\u5149\u6807\u79fb\u52a8\u5230\u7b2c\u4e8c\u4e2a\u53c2\u6570\u540e\u9762\u7684\u5bf9\u8bdd\u6846\u4e2d\uff0c\u5728\u5bf9\u8bdd\u6846\u4e2d\u8f93\u5165\u516c\u5f0f\u201c2*LEN(A2)-LENB(A2)\u201d\uff0c\u8bbe\u7f6e\u597d\u53c2\u6570\u540e\u70b9\u51fb\u3010\u786e\u5b9a\u3011\u6309\u94ae\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/3931cb413a8ca6089d1c4a4fdb8c9bcec6f8feaa.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1", "https://exp-picture.cdn.bcebos.com/a44e8afc508c9bcefbeb54c4d6dd884ce44afaaa.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u8fd4\u56de\u5230\u5de5\u4f5c\u8868\u4e2d\uff0c\u53ef\u4ee5\u770b\u5230A2\u5355\u5143\u683c\u7684\u7535\u8bdd\u53f7\u7801\u5c31\u5355\u72ec\u5206\u79bb\u51fa\u6765\u4e86\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/8b3643dd884ce54a6e34395ca3066b0193ddf7aa.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}, {"txt": "\u9009\u4e2d\u5355\u5143\u683c\uff0c\u62d6\u52a8\u9f20\u6807\u5de6\u952e\u5c06\u5269\u4f59\u7684\u7535\u8bdd\u53f7\u7801\u4ece\u4fe1\u606f\u5355\u5143\u683c\u4e2d\u5206\u79bb\u51fa\u5373\u53ef\u3002"}, {"img": ["https://exp-picture.cdn.bcebos.com/e6ae36066b0192dd755368401a87031c98c0f0aa.m2m?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1"]}], [{"txt": ["\u6ce8\u610f\u4e8b\u9879"]}, {"txt": "\u672c\u6587\u4ec5\u4f9b\u53c2\u8003\u3002"}]]