14,982
edits
Return symbol: Difference between revisions
Jump to navigation
Jump to search
→Excel 如何取代換行符號
m (→如何尋找與取代換行符號) |
|||
| Line 161: | Line 161: | ||
* {{kbd | key=CHAR(13)}} means "Carriage return"(LF, {{kbd | key=<nowiki>\r</nowiki>}}) 舊版 Mac 換行符號 | * {{kbd | key=CHAR(13)}} means "Carriage return"(LF, {{kbd | key=<nowiki>\r</nowiki>}}) 舊版 Mac 換行符號 | ||
* {{kbd | key=CONCAT(CHAR(13), CHAR(10))}} means "CRLF"({{kbd | key=<nowiki>\r\n</nowiki>}}) Windows 標準換行符號 | * {{kbd | key=CONCAT(CHAR(13), CHAR(10))}} means "CRLF"({{kbd | key=<nowiki>\r\n</nowiki>}}) Windows 標準換行符號 | ||
判斷是哪種換行符號： | |||
<pre> | |||
=IF(ISNUMBER(SEARCH(CHAR(13)&CHAR(10), A1)), "CRLF (\r\n)", | |||
IF(ISNUMBER(SEARCH(CHAR(13), A1)), "CR (\r)", | |||
IF(ISNUMBER(SEARCH(CHAR(10), A1)), "LF (\n)", | |||
"無換行符號"))) | |||
</pre> | |||
=== Python 如何取代換行符號 === | === Python 如何取代換行符號 === | ||