Oh, I see what you mean now.
http://www.w3schools.com/jsref/jsref_replace.asp
formattedValue = formattedValue.replace("\n", "<br/>\n");
-Vic
On Thu, Apr 7, 2011 at 1:24 PM, Mike <[email protected]> wrote:
> Dear Vic,
>
> Thanks for the answer! I carefully followed your instruction, but it
> didn't help. Replacing "\n" with "<br/>" creates a break line between
> rows, but still ignores the line breaks between my sample sentences in
> a cell and puts all of them in one line. Here's the test:
> http://sites.google.com/site/michaelmccolin/home
> I want the line breaks between the sentences, as you can see in the
> sample spreadsheet.
>