excel 2003 [Cell division function]

单元格提取函数CHAR(10) 是指单元格里面换行符得代码IF(ISERROR(FIND(CHAR(10),A1)),A1,LEFT(A1,FIND(CHAR(10),A1)-1))IF(ISERROR(FIND(CHAR(10),A1)),,RIGHT(A1,LEN(A1)-FIND(CHAR(10),A1)))例子下载