•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I find and remove certain texts in all cells?
Such as I have in "s__" in "s__uncultured_bacterium_g__Taibaiella“ and I want to remove it in all cells containing this text. I tried substitute ""s__" to "" both with Ctrl+H find and replace and formula but it said they are substituted though they still not.
Edit: tried Excel 2010 and 2016 and they work. Maybe it’s a bug in 2021 family.
[link] [comments]
Want to read more?
Check out the full article on the original site