•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
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#AI formula generation techniques
#financial modeling with spreadsheets
#formula generator
#Excel
#find and replace
#substitute
#cells
#formula
#text removal
#bug
#Ctrl+H
#version 2021
#find function
#uncultured_bacterium
#replace function
#Excel 2010