I have a sheet that has 4 columns and 32 rows. In Col D there are alpha and numerical data prefixed Annnn or Annn or Ann e.g. A1234 or A111 or A22. Each entry is separated by a ','.
I wish to count the number of occurrences of a Annn and / or Annn and/ or Ann in each specific cell, D2 to D32...