14,982
edits
Return symbol: Difference between revisions
Jump to navigation
Jump to search
m
→如何尋找與取代換行符號
m (→Excel 如何取代換行符號) |
m (→如何尋找與取代換行符號) |
||
| Line 153: | Line 153: | ||
</pre> | </pre> | ||
=== Excel 如何尋找換行符號 === | === Excel 或 Google Sheet 如何尋找換行符號 === | ||
判斷是哪種換行符號： | 判斷是哪種換行符號： | ||
<pre> | <pre> | ||
| Line 162: | Line 162: | ||
</pre> | </pre> | ||
=== Excel 如何取代換行符號 === | === Excel 或 Google Sheet 如何取代換行符號 === | ||
For Microsoft Excel or Google Sheet | For Microsoft Excel or Google Sheet | ||
* {{kbd | key=<nowiki>=CLEAN(A1)</nowiki>}} Use the CLEAN function to "remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from the text"<ref>[https://support.microsoft.com/en-us/office/clean-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41 CLEAN function]</ref>. Meanwhile, the return symbol will be removed from the text. | * {{kbd | key=<nowiki>=CLEAN(A1)</nowiki>}} Use the CLEAN function to "remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from the text"<ref>[https://support.microsoft.com/en-us/office/clean-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41 CLEAN function]</ref>. Meanwhile, the return symbol will be removed from the text. | ||
| Line 172: | Line 172: | ||
* {{kbd | key=CHAR(10)}} means "Line feed" (LF, {{kbd | key=<nowiki>\n</nowiki>}}) Unix/Linux 換行符號 | * {{kbd | key=CHAR(10)}} means "Line feed" (LF, {{kbd | key=<nowiki>\n</nowiki>}}) Unix/Linux 換行符號 | ||
For Google Sheet | For Google Sheet | ||
* {{kbd | key=<nowiki>=REGEXREPLACE(A1, "[\r\n]+", " ")</nowiki>}} replaces return symbols with spaces in cell {{kbd | key=A1}} in Google Sheets | * {{kbd | key=<nowiki>=REGEXREPLACE(A1, "[\r\n]+", " ")</nowiki>}} replaces return symbols with spaces in cell {{kbd | key=A1}} in Google Sheets | ||