title: create a macro to delete cell content in a column that meets certain criteria
body: <p>Hello can someone help me.
  I have three columns and I want to search each column and delete content if it meets 
  certain criteria.</p>
  
  <p>Column B delete only cells with names<br>
  Columns C delete only cells with the word tray and a number
  Column F delete only cells with * followed by four 0000 then ends with *
  This is what I came up with but it isn’t working and I am not sure what to do. I have searched and searched. How do I do this thanks?</p>
  
  <p>column B name column  cell format FN,LN  Clear any names from row 16 to lastrow. Some 'row may have dates and time I don’t want to touch those</p>
  
  <p>column C range format Tray 226985 clear the content of any rows in that column with the word tray followed by a number to the lastrow</p>
  
  <p>column F range format <em>000000226985</em> begins with a * then four 0000 and ends with a * delete cell content with that format to the lastrow</p>
  
  <pre><code>Sub Macro1()
  
  Range(b1, b65536).Value = ("*,*").clearcontent
  Range(c1, c65536).Value = tray(*).clearcontent
  Range(f1, f65536).Value = ("*0000*").clearcontent
  
  End Sub
  </code></pre>