troubleshooting Question

Delete the whole row if an entry in Column D has an underscore as part of the cell entry

Avatar of Andreas Hermle
Andreas HermleFlag for Germany asked on
Microsoft Excel
15 Comments1 Solution415 ViewsLast Modified:
Dear Experts:

I need to delete the whole row ...
... an entry in Column D has an underscore (or several ones) as part of the cell entry

I would like to run a macro code to achieve this or alternatively ..

... a conditional formatting solution (if feasible)

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 15 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros