1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Looking for a way to highlight cells that contain a specific word as part of a bigger word

Hey gang, got a sheet with several thousand cells with chunks of text in em (a paragraph or so of "issue description" type text). I'm looking for a way to highlight cells that contain a specific word as part of a bigger word.

eg - I'm looking for the word "sign". I want every cell that has a word that contains the word sign to be highlighted (consign, design, designate, etc etc).

My googling has lead me nowhere so I've come to the real pros for help

submitted by /u/DashLeGrand
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#real-time data collaboration
#cells
#sign
#highlight
#word
#specific word
#cell highlighting
#bigger word
#text
#Excel
#conditional formatting
#sheets
#issue description
#help