I have a database with 7500 plus entries.

The database is managed in an excel spreadsheet. There are about 25
fields for each entry. Each field is a separate column.

I am uploading my database online, and to maintain formatting (really
just line spacing, indenting and bulleted lists) when I upload the CSV
version of my spreadsheet online I need to put html code into three of
the columns that need formatting maintained. (basically a bunch of
line breaks <BR> and some paragraph and indent notations.) For me to
code the 7500 plus entries (x3 for each column that need this done)
with the proper html code that will maintain line breaks etc... would
take months. There has to be some way through excel, an add on
program, an external program, or a script. That will simply fill in
the proper html code in the cells on the sheet that would maintain
their current formatting as if it were to be a web page.

I know you can save it as a webpage in excel, which does exactly that,
it puts all the proper html coding to maintain formatting in its right
place... but then I no longer have my database because it is actually
a page. All I need is the html coding inserted into the cells to
maintain formatting when the data is uploaded online.

What and how can I do this? Everything ive found online so far just
converts the whole spread sheet to an html web page output, nothing
seems to put the coding right into the cells of the sheet. That?s what
im looking for.

---

Clarification of Question by masflow-ga on 16 May 2005 10:20 PDT

Here is a sample of ONE CELL(bare in mind I need to do this to 22,500
cells (*note: some are blank) to better clairify what I have... and
the conversion I'm looking for in the text of each individual cell...

Cell 'X' as it stands now:

----------------------------
4Life® Transfer Factor Plus Canine Complete?
Ensuring the Best Overall Health for Dogs

* Lets you take excellent care of your furred best friend.
* Provides an all-in-one formula to give your dog the nutritional and
immune support he/she needs.
* Supports your pooch to move freely, better cope with stress and live
a long, happy, healthy life.

Scientifically developed 4Life Transfer Factor animal formulas combine
comprehensive, balanced nutrition, including valuable vitamins,
minerals and antioxidants with the patented immune system support of
4Life Transfer Factor Plus® Advanced Formula.

4Life Transfer Factor Plus Canine Complete contains over 40 valuable
nutrients, including amino acids, probiotics, essential fatty acids,
4Life Transfer Factor Plus Advanced Formula and the 25 vitamins and
minerals considered essential for the optimal health of your dog?all
in a great-tasting formula your dog will love.

Success Stories

"I give the Feline and Canine Complete formulas to my cat and dog.
I?ve noticed that they both look more vibrant and bright and their
eyes are more alert. It?s a subtle change, but I definitely notice it
in them."
?Kassie F.
Spokane, Washington

"A nine-year-old female dog named Cody weighed about 35 pounds. She
developed an acute skin condition with intense itching in both ears.
For the next five to six months, the owners tried everything they
could, but with little relief for Cody. I advised a food change and
told them to get on 4Life Transfer Factor Canine Complete. There began
to be improvement almost right away. At the end of one month, her skin
and hair color looked great; her ears were normal. Cody?s been doing
great for over six months now."
?Ken Hansen, DVM
Santa Rosa, California
--------------------------------------------- 

Cell 'X' with the HTML text inserted to maintain proper formating on the internet:

---------------------------------------------
<p>
4Life® Transfer Factor Plus Canine Complete?<br>
Ensuring the Best Overall Health for Dogs
</p>

<p>
    * Lets you take excellent care of your furred best friend.<br>
    * Provides an all-in-one formula to give your dog the nutritional
and immune support he/she needs.<br>
    * Supports your pooch to move freely, better cope with stress and
live a long, happy, healthy life.
</p>

<p>
Scientifically developed 4Life Transfer Factor animal formulas combine
comprehensive, balanced nutrition, including valuable vitamins,
minerals and antioxidants with the patented immune system support of
4Life Transfer Factor Plus® Advanced Formula.
</p>

<p>
4Life Transfer Factor Plus Canine Complete contains over 40 valuable
nutrients, including amino acids, probiotics, essential fatty acids,
4Life Transfer Factor Plus Advanced Formula and the 25 vitamins and
minerals considered essential for the optimal health of your dog?all
in a great-tasting formula your dog will love.
</p>

<p>
Success Stories
</p>

<p>
"I give the Feline and Canine Complete formulas to my cat and dog.
I?ve noticed that they both look more vibrant and bright and their
eyes are more alert. It?s a subtle change, but I definitely notice it
in them."<br>
?Kassie F.<br>
Spokane, Washington
</p>

<p>
"A nine-year-old female dog named Cody weighed about 35 pounds. She
developed an acute skin condition with intense itching in both ears.
For the next five to six months, the owners tried everything they
could, but with little relief for Cody. I advised a food change and
told them to get on 4Life Transfer Factor Canine Complete. There began
to be improvement almost right away. At the end of one month, her skin
and hair color looked great; her ears were normal. Cody?s been doing
great for over six months now."<br>
?Ken Hansen, DVM<br>
Santa Rosa, California
</p>
----------------------------------------


There has to be some way to automatically generate the <br> and <p> notations.


I used http://www.newbiehangout.com/convert/Mt2h.cgi as an online text
to html conversion to put the html in the sample above, if this can be
done online, it has to be doable in excel... right?

Here's a silly idea: Let's say your data is in sheet1.. in Sheet2, you
mirror the data, only say... column A is represented as:
CONCATENATE("<TR><TD>",Sheet1!A10,"</TD>") and column B is represented
as CONCATENATE("<TD>", Sheet1!B10,"</TD>") .... the last column is
represented as CONCATENATE("<TD>", Sheet1!X10,"</TD></TR>").

Place any header HTML stuff
<HTML><HEAD><Title>Spreadsheet</TITLE></HEAD><BODY><TABLE> tag in A1
and a </TABLE></BODY></HTML> at the end of your data. Export the whole
sheet as text, tab delimited, and you're nearly there..

The B10 stuff is relative to your actual data, You can see how you can
copy paste that easily. Of course, where you want bold <B></B> and
italics<I></I> you can choose on your own.