Hi there and welcome
You can use this code to do this, you just put it in a macro that cycles through all rows
if Chr(ActiveCell.Column + 64) = "H" then
if InStr(1, ActiveCell.Value, "L") > 0 then
range("B" & ActiveCell.Row) = ""
If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.
Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.
How did you go with the Code David? As I saw you reviewed it but I never heard back.