=CONCATENATE(SUBSTITUTE(R2, CHAR(10), CHAR(32)) & " . . . " & S2)
CHAR(32) = SPACE . . . http://www.lookuptables.com/
Doesn't work.
This replaces the Line Feeds with a Space, which gets rid of all the extra quotes from when I copy and paste,
but, I need the Line Feeds . . . and now the text has a lot of extra Spaces
Bookmarks