Text in Cell Formatting

  • Thread starter Thread starter travelinman
  • Start date Start date
T

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?
 
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?
Click to expand...

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>.
 
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.
 
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.
Click to expand...

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