=IF(ISNUMBER(FIND(CHAR(10),A1)),SUBSTITUTE(A1,CHAR(10),"-"),A1)
B1中输入以上公式向下拖则可以把A列数据中的所以软回车换为-
=TRIM(SUBSTITUTE(B1,CHAR(13),""))
=TRIM(SUBSTITUTE(B1,CHAR(10),""))
B1中输入以上公式向下拖则可以把A列数据中的所以软回车换为-
=TRIM(SUBSTITUTE(B1,CHAR(13),""))
=TRIM(SUBSTITUTE(B1,CHAR(10),""))