You are viewing an old revision of this post, from July 21, 2017 @ 01:06:31. See below for differences between this version and the current revision.

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. [php]=regexreplace("cell with your data","\n"," ")[/php] [php]=regexreplace("cell with your data","\r"," ")[/php]

Revisions

  • July 21, 2017 @ 01:06:31 [Current Revision] by PeterLugg
  • July 21, 2017 @ 01:06:31 by PeterLugg

Revision Differences

There are no differences between the July 21, 2017 @ 01:06:31 revision and the current revision. (Maybe only post meta information was changed.)

Tags:

No comments yet.

Leave a Reply