I have a column with hundreds of rows.
In that column, each row has an article. The article contains many paragraphs.
I want to insert a line break where each sentence ends and 2 line breaks where each paragraph ends.
I need to do this so I can import the whole spreadsheet into my site where the article will be displayed properly as per the formatting done within excel.
I know CHAR(10) adds a line break, but how do I do this with multiple paragraphs?
The reason why I think its a problem is because I know you have to have speech marks around the rest of the text before and after each line break.
Furthermore, you need to start the article with a = sign.
Have I understood it wrong or is there a better way?
Thanks,
JH
Bookmarks