14,982
edits
Return symbol: Difference between revisions
Jump to navigation
Jump to search
m
→Excel 如何尋找換行符號
m (→Excel 如何取代換行符號) |
m (→Excel 如何尋找換行符號) |
||
| Line 154: | Line 154: | ||
=== Excel 如何尋找換行符號 === | === Excel 如何尋找換行符號 === | ||
判斷是哪種換行符號： | |||
<pre> | <pre> | ||
=IF(ISNUMBER(SEARCH(CHAR(13)&CHAR(10), A1)), "CRLF (\r\n)", | =IF(ISNUMBER(SEARCH(CHAR(13)&CHAR(10), A1)), "CRLF (\r\n)", | ||
| Line 161: | Line 161: | ||
"無換行符號"))) | "無換行符號"))) | ||
</pre> | </pre> | ||
=== Excel 如何取代換行符號 === | === Excel 如何取代換行符號 === | ||