Remove line breaks in a Google Spreadsheet cell

The first formula replaces line breaks with a space and the second formula replaces paragraph breaks with a space.

=regexreplace("cell with your data","\n"," ")
=regexreplace("cell with your data","\r"," ")

Revisions

Tags:

No comments yet.

Leave a Reply