5 Replies Latest reply on Jul 10, 2018 9:24 PM by Deepak Rai

    Count words/names separated by commas

    Imesh Bandara

      Hi guys,

       

      I am trying to count the total number of counts of country names in a single column. In some rows, multiple countries present separated by commas. I want to count each and every time the country name has appeared.

      Can you please advise?

      The datasheet is attached here.

      Many thanks!

       

      Imesh.