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