摘要:=MID(A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),2*LEN(A2)-LENB(A2)) 第一,如果需要提取数字的源数据没有字母出现,只是汉字和数字,可以使用这个公式提取数字: =MIDB(A2,SEARCHB("?",A2),2*LE
阅读全文
Copyright @
2025 明净
Powered by .NET 9.0 on Kubernetes
Powered by:
.Text and
ASP.NET
Theme by: .NET Monster