Notepad++ & Excel

copy html from notepad and paste in excel

[gecko001]

I want to be able to edit small amout of html in notepad++ and then copy and paste into excel for upload to a mysql database...
the code is simple

<b>Title</b>
<ul>
<li>Strong enough to take all the weight you can carry.</li>
<li>Your gear will stay dry </li>
<li>No need to carry a liner</li>
<li>Exclusive non-slip waist buckle able to handle any load. </li>
<li>Folds down to a waistbag </li>
<li>The short pile won't catch grass seeds and stays looking great year after year</li>
<li>Comfortable underload with foam lined hip area</li>
</ul>
<b>Specifications</b>

The only problem is that excel will not take it without formating it...somehow i need to remove returns and tabs....has anyone run into this problem before?

[gecko001]

sorry for extra post
what i meant was my data is jumping down the excel colum into other cells.
I just want on string of text in one cell that has html tags in it.

[le_gber]

if you want all that code into one cell remove all the carriage return from the code ie. in notepad ++ you'd have:

<b>Title</b><ul><li>Strong enough to take all the weight you can carry.</li><li>Your gear will stay dry </li><li>No need to carry a liner</li><li>Exclusive non-slip waist buckle able to handle any load. </li><li>Folds down to a waistbag </li><li>The short pile won't catch grass seeds and stays looking great year after year</li><li>Comfortable underload with foam lined hip area</li></ul><b>Specifications</b>

[gecko001]

Thank You that is exactly the result i want.

BUT is there a way to quickly remove carrige returns in notepad++ rather than go through the whole lot manually?

Gecko

[le_gber]

yes what you have to do is go at the end of the first line with your mouse and place the cursor there.
click and drag the selection to the first character on the second line.
hit 'ctrl + h'

the search and replace box should appear with squares in the search for box / drop down

hit replace all and it will remove all the carriage returns.

[le_gber]

I just found that doing

'ctrl + a' select all
'ctrl + j' join lines

is even quicker