Thanks for the reply - I don't do programming so am going with another of the
solutions offered.

"Gary''s Student" wrote:

Select your cells and run:

Sub cleaner()
For Each r In Selection
If Application.WorksheetFunction.IsText(r.Value) Then
If Left(r.Value, 3) = "ASD" Then
r.Value = ""
End If
End If
Next
End Sub

--
Gary''s Student - gsnu200753


"Mary Ann" wrote:

I have a very large list of data which includes a column containing codes.
The codes might be just numbers or they could have letters in them as well.
If the code for the particular item starts with, lets say, ASD I want to
delete all the data in the cell.

How do I achieve this?

I am a sophisticated user of Excel but do not do programming