Text in Cell Formatting

[travelinman]

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?

 

[Sheeloo]

No, not without using a macro.

 

[travelinman]

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

 

[Ron Rosenfeld]

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>.

 

[travelinman]

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]

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