View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_5_] Dave Peterson[_5_] is offline
external usenet poster
 
Posts: 1,758
Default Search & Replace Formatting for part of cell

ps...

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Tanya B wrote:

Good Morning,

Win XP
Excel '03

I need to do a search and replace for formatting for a single word in a cell
of multiple words. Ex. I want to replace Textile <no formatting with
Textile <strikethrough and textile may not always be the only word in the
cell. When I do a standart S&R it formats the whole cell, I only want the
word. I figured this would have to be accomplished with VB code. Please
advise.


--

Dave Peterson