Hello,
I would like to convert my cell text to html or add HTML to it and keep
the data in the cell. I need to upload my excel database to a software
that requires the cell data to be HTML ready. It has to have the
neccessary tags so the whole cell text is HTML ready. I have over a
1000 files so doing it manually would not be practical. Some of the
cells have a large amount of data in them. The cell contains text that
is not formatted. The cell data I have right now looks something like
this:

_*ColumnA*_
__________________________________________________ _________
Barley Water
2 Tbs pearl barley
4 cups water
Put barley over the fire in cold water, let come to a boil and cook 5
min. Then drain off the water and rinse the barley in cold water.
Return to the fire. Add 1 quart of water. Bring to a boil again and
simmer until reduced by 1/2. This may be sweetened or flavored. This is
highly nourishing.
__________________________________________________ _________

Oatmeal Gruel
1/2 cup oatmeal
6 cups boiling water
1 tsp salt
sugar and cream
Add salt to the boiling water. Stir in the oatmeal and cook for 2 1/2
hours in a double boiler. Remove from fire and strain. When preparing
it for a patient, use 1/2 cup gruel mixed with 1/2 cup thin cream, 2
in. boiling water and sugar to taste.
__________________________________________________ _____________

Flax Seed Lemonade
2 Tbs Flaxseed
4 cups boiling water
1 cup sugar
Juice and grated rind of 3 lemons
__________________________________________________ ____________


IF you have any questions please ask. I have 2003 MS Excel and MS
Access.
Thank you. Have a nice day.
Rob


--
tryin2makeit2
------------------------------------------------------------------------
tryin2makeit2's Profile: http://www.excelforum.com/member.php...o&userid=19147
View this thread: http://www.excelforum.com/showthread...hreadid=499190