ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I only want to change the formatting of one word in an Excel cell (https://www.excelbanter.com/excel-discussion-misc-queries/143089-i-only-want-change-formatting-one-word-excel-cell.html)

Mark B

I only want to change the formatting of one word in an Excel cell
 
I've done this on other worksheets but it won't work on this new one.

I have several words entered into an Excel cell. I want to make only one of
the words BOLD and I want to change the font of all others. Excel keeps
converting all characters in the cell.

Mike H

I only want to change the formatting of one word in an Excel cell
 
Select the cell, highlight the word you want bold in the formula bar and then
select bold.

Mike

"Mark B" wrote:

I've done this on other worksheets but it won't work on this new one.

I have several words entered into an Excel cell. I want to make only one of
the words BOLD and I want to change the font of all others. Excel keeps
converting all characters in the cell.


Mark B

I only want to change the formatting of one word in an Excel c
 
Thanks. I had tried that and couldn't get it to work. But, I have found the
problem. The cell format was a custom format using a numerical formating.
Once I changed this to General, I was able to do the formatting word by word.

"Mike H" wrote:

Select the cell, highlight the word you want bold in the formula bar and then
select bold.

Mike

"Mark B" wrote:

I've done this on other worksheets but it won't work on this new one.

I have several words entered into an Excel cell. I want to make only one of
the words BOLD and I want to change the font of all others. Excel keeps
converting all characters in the cell.



All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com