Thread: Count text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kristina Kristina is offline
external usenet poster
 
Posts: 8
Default Count text

Hi.... I need to count the number of times each store appears (LEFT by 4
characters):
edar wkub
edar02
edar02
edar01
wkub01
wkub02
emur01

Result: Store "edar" appears 3 times; "wkub" 2 etc.

Thank you very much!!!