Hello,

I am really looking solution for this. I have contents in which I need to add
at the end of each line in excel and I don't know how to do it. Here is the example

PRODUCTION AND DEMAND

Anesthetic Drugs Sales Volume
Anesthetic Drugs Sales by Classification in 2008
Anesthetic Drugs Import
Anesthetic Drugs Export
Anesthetic Drugs Market Share by Classification in 2008

I want it to be look like this

PRODUCTION AND DEMAND < br>

Anesthetic Drugs Sales Volume< br>
Anesthetic Drugs Sales by Classification in 2008< br>
Anesthetic Drugs Import< br>
Anesthetic Drugs Export< br>
Anesthetic Drugs Market Share by Classification in 2008< br>

Also if there is more ENTER than two want to remove it.

Example:

PRODUCTION AND DEMAND
-enter space
-enter space
-enter space
-enter space
Anesthetic Drugs Sales Volume
Anesthetic Drugs Sales by Classification in 2008
Anesthetic Drugs Import
Anesthetic Drugs Export

Can put only enter that's why I add (-enter space) Want to remove the enter space if it's increase more than two.

Please help me in this I have lots of content in the column like this to be fixed.

Thanks,
Best regards