Deleting cell contents based on partial content?

  • Thread starter Thread starter Jordon
  • Start date Start date
J

Jordon

Is it possible to delete the contents of all cells in a named range based
on the partial contents of those cells?

I import data from a database that ends up having thousands of cells
whose contents start with 3 asterisks and end with 3 asterisks and I'm
looking for a way to delete them all, not just the asterisks but everything
in those cells.

TIA,
 
Can you sort the data to group all the "***" together, then just delete the
selected rows or cells? Then sort them back to the original order.

Keith
 
Thanks for the suggestion. That's what I'm doing now but it takes a long
time.
The data I'm working with is in 30 different columns and the entries with
asterisks start in different rows for different columns. I have to sort it
about
5 times to get all of them.
 
Back
Top