A2公式下拉: =IF(F2="","","PM"&TEXT(CODE(F2)-64,"0000")) PS:按照你新的叙述,估计能能用VBA来做了!告知邮箱号~ ...全文. 追问. 非常感谢 [email protected].
確定! 回上一頁