15,076
edits
Return symbol: Difference between revisions
Jump to navigation
Jump to search
m
→Excel 如何取代換行符號
m (→Excel 如何取代換行符號) |
|||
| 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 換行符號 | ||
=== Google Sheet 如何取代換行符號 === | |||
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 | ||