Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
Find and Replace without changing font | Excel Discussion (Misc queries) | |||
Excel - create button to replace cell content with cell value | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel |