提取excel单元格内的第三个不规则数字函数怎么写

可以使用以下公式提取单元格内的第三个不规则数字：

=MID(A1,MIN(IFERROR(FIND({"0","1","2","3","4","5","6","7","8","9"},A1,ROW(INDIRECT("1:"&LEN(A1))))+2^15,2^15)),MIN(IFERROR(FIND({"0","1","2","3","4","5","6","7","8","9"},A1,MIN(IFERROR(FIND({"0","1","2","3","4","5","6","7","8","9"},A1,ROW(INDIRECT("1:"&LEN(A1))))+2^15,2^15))+2^15,2^15))-MIN(IFERROR(FIND({"0","1","2","3","4","5","6","7","8","9"},A1,MIN(IFERROR(FIND({"0","1","2","3","4","5","6","7","8","9"},A1,ROW(INDIRECT("1:"&LEN(A1))))+2^15,2^15))+2^15,2^15)))

其中，A1是要提取数字的单元格