Forum Discussion
DavidMunoz
Apr 16, 2021Copper Contributor
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"
1 Reply
Sort By
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.