View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mary Ann Mary Ann is offline
external usenet poster
 
Posts: 31
Default 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