View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Stephanie M Stephanie M is offline
external usenet poster
 
Posts: 5
Default Replace Font within Cell

Thanks. I have a lot of cells to change. The only way I how to create a Macro
is to have it copy the actions.

"Ron Rosenfeld" wrote:

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