•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Highlighting certain text contained within a text issue
Our take
In this discussion, the user seeks assistance with highlighting specific text within a complex column. They want to highlight instances of "CRAF" only when "RAF" appears as a separate word in the same column. The challenge arises due to the presence of multiple words and phrases in each cell, which complicates the formula needed for effective highlighting. With a clear example provided, the user is looking for guidance to create the appropriate formula that meets their requirements and enhances their data management experience.
Hi guys! Confusing title. Hopefully I can explain this better.
I am trying to highlight a column that contains the text “RAF”, however I have a “CRAF” also in that column. The column also contains many lines that say CRAF RAF. I only want it to highlight the columns with CRAF if RAF is present as a separate word.
I’ve tried to do a text to column since CRAF should be the first word on any row. But some of the rows in this column are 20-30 words and RAF could be in any of the other words.
I’ve focused on an example of a cell. I am just struggling with the formula to use. Please help!
Example in comments.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience