Questions about paragraphs in one cell

When there are some paragraphs in one cell, it works well in excel; but when converting the excel to text or html, no paragraph tag is converted. As a result, all paragraphs are in one line. In other words, lines in the excel cell are no longer valid and each cell is just one continuous line in text file.

Now I have two questions:

1. How to add tags like <p> or <br> between the lines to keep the paragraph structure in text file too.

2. How to delete a line in a cell? For instance, deleting any line (in the body of a cell) beginning with a character like "@".

Originally Posted by oldchippy

Hi,

To answer the first question take a look here

http://www.ascii-code.com/

Type something like this in a cell

="Hello"&CHAR(13)&"World"

it will appear as one line, then copy it and paste it into WordPad and it is now two lines

Thanks for such a useful information oldchippy,
However, I still see no practical solution. My problem is that two lines in excel are shown one line in WordPad. How can I convert the html tags into excel cells?

For instance, I need to replace "ENTER" in the excel cells with "<br>".

Originally Posted by martindwilson

think we need to see an example

Ok, imagine the following excel structure

A B
Row1 Text of line1.
Text of line 2.
Text of line 3.
Row2 line1 of another cell.
line2 of the same cell.
line 3 of the same cell.

when saving this file as CVS it will appears like

Row1, Text of line1.Text of line 2.Text of line 3.
Row2, line1 of another cell.line2 of the same cell.line 3 of the same cell.

Now if opening such text in a html browser; there will be no paragraph or lines.


A solution is modify the excel file to

A B
Row1 Text of line1.<br>
Text of line 2.<br>
Text of line 3.<br>
Row2 line1 of another cell.<br>
line2 of the same cell.<br>
line 3 of the same cell.<br>

For this purpose, it is needed to deal with every single lines in the body of a cell.

Originally Posted by oldchippy

Hi,

Why not just save it as a Web page then it keeps the formatting

because I am talking about many independent rows