View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Is there anything like the Access "LIKE" function in Excel?

Identify is a little vague. Are you trying to aggregate based on finding CU
in a field. If so then check out this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Check out example 9 at the bottom.

If you just want to know if a cell is contains CU then you can use Find or
Search. Look them up in help.
--
HTH...

Jim Thomlinson


"pa1971" wrote:

I would like to identify only the values in a spreadsheet with "CU" included
in them. That "CU" could be at the beginning, end or middle of the values in
the column. In access I could use the LIKE feature. Is there anything
similar in Excel to identify them?

Thank you!