View Single Post
  #2   Report Post  
Paul Sheppard
 
Posts: n/a
Default


Use the formula =LEN(Cell Ref) where Cell Ref is the cell reference of
the product code, this will return a value equal to the number of
characters in the product code, then do a filter for the 4


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=391277