View Single Post
  #1   Report Post  
Steve
 
Posts: n/a
Default Find Replace bold formatting with delimiter

Hi,



I have paragraphs whose first couple of words are in bold and represent
titles of magazines and then immediately following a description of the
magazine in plain text. I would like to parse these into separate fields by
placing a delimiter between the bold text and plain and then doing a Text to
Columns in Excel. So, if I used the ampersand '@' as a delimiter I would
like to do the following:



Before Find Replace

boldInterior DesignboldA magazine on the interior design industry.



After Find Replace

boldInterior Designbold@A magazine on the interior design industry.



It doesn't matter if the title remains bold so long as a delimiter is placed
between it and the description.



Thanks - Steve