Created
May 1, 2015 12:54
-
-
Save jamesstacyjones/1a77649f24a81c7d7294 to your computer and use it in GitHub Desktop.
Remove Line Breaks from a Cell in Google Sheets
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Copy this Regular Expression into Find / Replace: | |
\r\n|\n|\r | |
Then click 'Replace All' and bye bye line breaks. | |
[note] make sure there is no white space before or after the expression |
@knope follow this method in combination with the above gist https://webapps.stackexchange.com/a/82866
@knope It still does. Make sure you chose the regex option on all sheets in the find&replace tab.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
this no longer seems to work ... :(