Skip to main content
added 27 characters in body
Source Link
Aurielle Perlmann
  • 4.9k
  • 1
  • 15
  • 21

the formula you would want is

=regexreplace("cell with your data","\n""(\n)(\n{1,""})  ","$1")

or

=regexreplace("cell with your data","\r""(\r)(\r{1,""})","$1")

the first one replaces new lines and the second on replaces carriage returns if needed.

the formula you would want is

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

or

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

the first one replaces new lines and the second on replaces carriage returns if needed.

the formula you would want is

=regexreplace("cell with your data","(\n)(\n{1,})","$1")

or

=regexreplace("cell with your data","(\r)(\r{1,})","$1")

the first one replaces new lines and the second on replaces carriage returns if needed.

Source Link
Aurielle Perlmann
  • 4.9k
  • 1
  • 15
  • 21

the formula you would want is

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

or

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

the first one replaces new lines and the second on replaces carriage returns if needed.