View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ela ela is offline
external usenet poster
 
Posts: 16
Default replace a single character WITH FORMAT in a cell

if i have a cell as "I am a boy"

and I would like to replace all the a's in this cell with red a's

How can i achieve that? it seems Excel will replace the whole cell content
into red...