Darlene

You can put the string in the clipboard, then paste special as Unicode text.
See here

http://www.dicks-blog.com/archives/2...l-in-cells-ii/

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Darlene wrote:
I ran a SQL query through VBA in Excel. Our database is web-based
and folks use HTML tags in their text (we then send reports through
Crystal Reports). When this text is inserted into Excel, it keeps the
tags. Is there an easy way to replace words, for instance, that
should be bold that have the bold tags using a macro or replace?