•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?
Our take
If you're looking to find and remove specific text, such as "s__," from all cells in your spreadsheet, you may encounter some challenges, especially if you're using Excel 2021. While older versions like Excel 2010 and 2016 may handle this task smoothly with the Find and Replace function, you might notice discrepancies in the 2021 version. This guide will help you navigate the process effectively, ensuring that you can achieve your desired results and streamline your data management experience.
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]
Read on the original site
Open the publisher's page for the full experience