View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Replace Font within Cell

On Tue, 28 Oct 2008 11:24:01 -0700, Stephanie M
wrote:

Is it possible to replace only specific characters/text within a cell? For
example I have several cells that need to have one word in italtics, but when
I use find and replace, all words in the cell are changed to italics.


If you have entered the text in the cell directly,
select the cell
select the particular characters within the cell (highlight them)
right-click and select the font changes

Note that the data MUST be TEXT.

If the text string is the result of a formula, you cannot do this.

This can also be done with a VBA Macro.
--ron