I have a standard text statement in multiple cells. I would like to have
certain words in the statement highlighted Bold. I used the Find and Replace
tool and under options selected Find What text and replace it with the same
text only bolded. I selected Options and then Bold under the Format drop down
menu. When I select Replace it bolded all the text in the cell.
Is it possible to only search, change the format and replace just portions
of a text statement in a cell?

No, not without using a macro.

"travelinman" wrote:

I have a standard text statement in multiple cells. I would like to have
certain words in the statement highlighted Bold. I used the Find and Replace
tool and under options selected Find What text and replace it with the same
text only bolded. I selected Options and then Bold under the Format drop down
menu. When I select Replace it bolded all the text in the cell.
Is it possible to only search, change the format and replace just portions
of a text statement in a cell?

Thanks for confirming my problem, that is what I thought.

"Sheeloo" wrote:

No, not without using a macro.

"travelinman" wrote:

I have a standard text statement in multiple cells. I would like to have
certain words in the statement highlighted Bold. I used the Find and Replace
tool and under options selected Find What text and replace it with the same
text only bolded. I selected Options and then Bold under the Format drop down
menu. When I select Replace it bolded all the text in the cell.
Is it possible to only search, change the format and replace just portions
of a text statement in a cell?

On Tue, 31 Mar 2009 08:06:01 -0700, travelinman
wrote:

I have a standard text statement in multiple cells. I would like to have
certain words in the statement highlighted Bold. I used the Find and Replace
tool and under options selected Find What text and replace it with the same
text only bolded. I selected Options and then Bold under the Format drop down
menu. When I select Replace it bolded all the text in the cell.
Is it possible to only search, change the format and replace just portions
of a text statement in a cell?

Assuming that the text entries are "strings" and are not the result of
formulas, you can

1. Locate the cell containing the string.
2. In edit mode, select the substring you wish to have bolded (with the
cursor).
3. Select BOLD (or other format options), then <enter.

-------------------
If you want to use something similar to the Find/Replace feature of Excel, you
will need a VBA macro.

--ron

That is what I ended up doing to each cell individualy. I was hoping for a
search and replace feature but I guess you can't have it all.

"Ron Rosenfeld" wrote:

On Tue, 31 Mar 2009 08:06:01 -0700, travelinman
wrote:

I have a standard text statement in multiple cells. I would like to have
certain words in the statement highlighted Bold. I used the Find and Replace
tool and under options selected Find What text and replace it with the same
text only bolded. I selected Options and then Bold under the Format drop down
menu. When I select Replace it bolded all the text in the cell.
Is it possible to only search, change the format and replace just portions
of a text statement in a cell?

Assuming that the text entries are "strings" and are not the result of
formulas, you can

1. Locate the cell containing the string.
2. In edit mode, select the substring you wish to have bolded (with the
cursor).
3. Select BOLD (or other format options), then <enter.

-------------------
If you want to use something similar to the Find/Replace feature of Excel, you
will need a VBA macro.

--ron

On Tue, 31 Mar 2009 13:15:04 -0700, travelinman
wrote:

That is what I ended up doing to each cell individualy. I was hoping for a
search and replace feature but I guess you can't have it all.

If you will be doing this repeatedly in the future, it might be worthwhile to
have a macro to accomplish this task.
--ron