View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kryten[_2_] Kryten[_2_] is offline
external usenet poster
 
Posts: 1
Default Delete a cell value if not "like"

Hi,

Is there any way, without using VBA, to delete cell values for an
entire column IF the current cell value is NOT LIKE a predefined
value. Ideally the predefined value would be a regex.

Thanks,
Stuart