View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CarlC CarlC is offline
external usenet poster
 
Posts: 2
Default Find formatting in text in cell, insert tags around formatting.

Hi,

I have cells containing bold or italic words within the text. I would like
to be able to search for the various formatting within the cells, insert tags
around the formatted words, and then remove the formatting.

The tags look like: <emph render="name of formatting"formatted words</emph

Example:
Suppose the words "quick brown" were in bold, the text should look like:
"The <emph render="bold"quick brown</emph fox jumps over..."

Is there an easy way to search for formatting within a cell and identify the
formatted words so that the tags can be inserted?

Thank
-Carl