Office

Excel常用知识分享

替换ascii码

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2, CHAR(10), ""), CHAR(13), ""), CHAR(36), "")