Forum Discussion

DavidMunoz's avatar
DavidMunoz
Copper Contributor
Apr 16, 2021

Change the format of a word in an excel file

Hi all,

 

I have an excel document with multiple cells. All the cells have text (different words) and some of those cells contain the word "YES".

 I want to change the format of those "YES" words (and only those words) to bold but when I use the replace function to change the format of all the ocurrences of the word "YES", Excel changes to bold all the text of te cells that contain the word "YES"

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 16, 2021

    DavidMunoz 

    It works with entire cell value, you can't reformat part of the string such way. That's manually by selecting part of the text and applying desired format; or VBA programming.

Resources