提取数据英文

只有用vba完成

假设数据在A1:A100，B1中输入=MID(A1,MATCH(,N(INDIRECT(MID(A1,ROW($1:$99),1)&50000)),),COUNT(N(INDIRECT(MID(A1,ROW($1:$99),1)&50000))))同时按下CTRL+SHIFT+回车，输入数组公式，下拉。

I turn to remove 1/2,1/3,1/4 from the data in the database

提供一个最不用动脑又快速的简便方法：使用Excel插件_(:3 」∠)_

下载安装【粉笔Excel智能插件】，然后在新增的【粉笔办公】菜单栏，选中【英文】点【提取】，选择提取后放置的目标区域，英文就提取OK了。数字也同理，选【数字】点【提取】，数字也提出来了。

The technology of data mining can be applied to effectively analyse,sort out the data and provide with effective and timely information for the ones who need the data.This article can be divided into five parts to explain the application of the data mining technology in CRM,to briefly explain what is CRM,and analyse the reason why the technology can be applied in CRM.