1.去掉单元格的特定字符 SUBSTITUE(“#”,“”) 比如A1为DPA#501&7879 B1= SUBSTITUE((SUSTITUE(A1,"#",""),"&","")即可在B1中得到DPA5017879