3 Replies Latest reply on Oct 17, 2017 7:17 AM by Jiwon Kye

    How can I count  and parse words in column?

    Jiwon Kye

      Hello. Everybody.

       

      How can I count  and parse words in column?

       

      I've made a sample file and attached below.

       

      I'd like to count only [].

       

      Fox : 0

      a Cute [Rabbit] : 1

      [Zebra], [Monkey] : 2

      Wow, There many animals. [Lion],..[Tiger][Bear]. : 3

       

       

       

      "FInd Function" does not seem to fit well with this problem.

       

       

      Help me!