数据格式如下:
解决方案如下:
PDF文件处理流程如下:
==================================================
【1】截图放入微信,复制文本粘贴到xls文件某列;(或ORC提取图片文本)
【2】增加列及转换列文本数据成数值列;
【3】关联数值列,并按照数值列排序;
【4】删除数值列表;(或无用的数据)
=====================================
【2】相关函数
============================
=SUBSTITUTE(B1:B80,"-10","9.10")
=SUBSTITUTE(C1:C80,"-11","9.11")
=SUBSTITUTE(D1:D80," ","")
============================
=SUBSTITUTE(SUBSTITUTE(D1:D80,"-",""),"A00","")
【2】合并后的函数
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1:A80,"-10","9.10"),"-11","9.11"),"-",""),"A00","")
【3】关联后的效果如下