I need help figuring out how to find certain contents in more than one cell (in the same column) and delete all contents in the cell, without the deleting the cell itself. I want a blank space. Example: a column has "850-777-8888" and also in the same column but row below "test@testgmail.com" I want to find anything with ".com" and delete "test@testgmail.com" but leave the cell there but blank.
Solved by B. H. in 25 mins