J
jmn13
The following capability has been lost in Excel 2003 Professional Edition -
WHY?
Using the "Find or Replace dialog, clicking on the "Options>>" button for
Replace, then the Format button", specifying a font format, and then clicking
on the "Replace All" button results in all of the text in the cells which
contain the "Find What" text string being formatted with the font format
option and not just the text string specified in the "Replace with" box.
What I am attempting to do is "Find and Replace" within all the cells in a
column or row the text string "shall" with the text string "shall" <bold,red>
and not affect any of the other text within each cell. Note: it could be any
text string not just "shall".
For example a cell that contained;
"Excel shall not format any text in a cell except the text string specified
in the "Replace with" box"
Would become;
"Excel (shall <bold, red>) not format any text in a cell except the text
string specified in the "Replace with" box"
This is very frustrating because this could be done in previous versions of
Excel but has apparently been lost in the current 2003 Professional Edition.
=====================
WHY?
Using the "Find or Replace dialog, clicking on the "Options>>" button for
Replace, then the Format button", specifying a font format, and then clicking
on the "Replace All" button results in all of the text in the cells which
contain the "Find What" text string being formatted with the font format
option and not just the text string specified in the "Replace with" box.
What I am attempting to do is "Find and Replace" within all the cells in a
column or row the text string "shall" with the text string "shall" <bold,red>
and not affect any of the other text within each cell. Note: it could be any
text string not just "shall".
For example a cell that contained;
"Excel shall not format any text in a cell except the text string specified
in the "Replace with" box"
Would become;
"Excel (shall <bold, red>) not format any text in a cell except the text
string specified in the "Replace with" box"
This is very frustrating because this could be done in previous versions of
Excel but has apparently been lost in the current 2003 Professional Edition.
=====================