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
- July 21, 2017 @ 01:06:31 [Current Revision] by PeterLugg
- July 21, 2017 @ 01:06:31 by PeterLugg
No comments yet.