Hi All,
I'm hoping that someone can give me a tip here. I'm working on a website at the moment and I need to do a data dump from and excel spreadsheet into a MySQL database. All is fine except that the product decriptions need to be reformatted to include HTML tags. With over 2000 products this is going to take some time. Is there a way to get Excel to add these tags into the appropriate cells? It must be able to do it, because I can generate HTML pages no problems, and converts all the cells to include HTML tags, but I just want it to add them to the cells so I can then import them into the MySQL database.

Thanks in advance for any help.