Deleting all data in cell if value starts with 3 particular letter
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
|