Eliminate extra lines within cell

Within one column (F) cells, I have information containing HTML coding such as html, body, div align, etc.

I got rid of those by Finding <*> and replacing with nothing.

However, now within the cells, there are unnecessary lines which need to be removed.

Cell F2 contains the following:
[blank line]
Text 1,2,3,4
[blank line]
Text 5,6,7,8
[blank line]
[blank line]
[blank line]

What I want to fix is to eliminate the blank lines at the beginning and end of the cell information:
Text 1,2,3,4
[blank line]
Text 5,6,7,8

Originally Posted by FDibbins

So this is all withing 1 cell - or across multiple cells?

This is all within 1 cell. Each cell in this column includes information such as the example I provided above.

Originally Posted by FDibbins

Try a Find/Replace for Char 10

Won't that eliminate the extra line between my texts as well? I only want to remove the Char 10 at the beginning and end of the text in the cell

I used

Please Login or Register  to view this content.

However, this also removed the space between my texts. Maybe I am setting up the formula incorrectly?

Originally Posted by shre0047

Within one column (F) cells, I have information containing HTML coding such as html, body, div align, etc.

I got rid of those by Finding <*> and replacing with nothing.

However, now within the cells, there are unnecessary lines which need to be removed.

Cell F2 contains the following:
[blank line]
Text 1,2,3,4
[blank line]
Text 5,6,7,8
[blank line]
[blank line]
[blank line]

What I want to fix is to eliminate the blank lines at the beginning and end of the cell information:
Text 1,2,3,4
[blank line]
Text 5,6,7,8

Select the cell(s) that you want to apply then run the code.

Please Login or Register  to view this content.