View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Spreadsheet function that mimics "LIKE"

Is there a spreadsheet function that works like "Like" in VBA? I need to use
a spreadsheet function to identify if a certain pattern exists in a cell for
example:

###.###.####.######.###.##.###

I know this can be done in VBA, as I myself have used it often. But, is
there a spreadsheet function equivalent to "Like"?

If so, please post back with it. Thanks much in advance.