[已解决]有什么方法可以去除里面的汉字

yysfcq

分离里面的汉字

生产加工单号(手工填写)	想要结果
T-XS202202081后端组	T-XS202202081
SCBL20220215射出组	SCBL20220215
SCBL20220215缺料清单	SCBL20220215
RFORECAST-202201230下料组	RFORECAST-202201230
HT-XS202202081-3-5输出组	HT-XS202202081-3-5
HT-XS202201058-2中间组	HT-XS202201058-2
HT-XS202201029中间组	HT-XS202201029
HT-XS202201029前端组	HT-XS202201029
HT-XS202201029料架组	HT-XS202201029
HT-XS202201029后端组	HT-XS202201029
HT-XS202201029焊耳组	HT-XS202201029
HT-XS202201029海绵组	HT-XS202201029
HT-XS202201029共用	HT-XS202201029
HT-XS202201029对折组	HT-XS202201029
FORECAST-20220211-1中间	FORECAST-20220211-1
FORECAST-20220211-1前端	FORECAST-20220211-1
FORECAST-20220211-1后端	FORECAST-20220211-1
Forecast-20220114中间组	Forecast-20220114
Forecast-20220114前端组	Forecast-20220114
Forecast-20220114后端组	Forecast-20220114
Forecast-20220114海绵组	Forecast-20220114
Forecast-20220114共用	Forecast-20220114
Forecast-20220114对折组	Forecast-20220114
CY20220125051中端组	CY20220125051
CY20220125051前端组	CY20220125051
CY20220125051前端方通机架	CY20220125051
CY20220125051机架零件	CY20220125051
CY20220125051机加	CY20220125051
CY20220125051后端组/共用	CY20220125051
CY20220125051后端组&共用	CY20220125051
CY20220125051后端组	CY20220125051
CY20220125051焊耳组	CY20220125051
CY20220125051焊耳方通架	CY20220125051
CY20220125051海绵组/共用	CY20220125051
CY20220125051海绵组	CY20220125051
CY20220125051共用	CY20220125051
CY20220125051封边	CY20220125051
CY20220125051对折组	CY20220125051
CY20220125051对折方通架	CY20220125051

最佳答案

月排行榜 / 总排行榜

风林火山

2022-4-1 09:03

=LEFT(A1,2*LEN(A1)-LENB(A1))

跳转到最佳答案楼层

风林火山

=LEFT(A1,2*LEN(A1)-LENB(A1))

高

试试快速填充功能