3 Replies Latest reply on Jun 6, 2012 6:33 AM by Alex Kerin

    How to separate strings in one column to many columns having single quotes as separator?

    Narayanan VS

      I have a set of strings in below format in one cell:

      For example in Cell 1 :

      'Condition' : 'Description of condition' from 'source of condition' of type 'type of condition'

      I need to separate each phrase into individual cell, column wise using the separator ' '. How do I do it?

      Eg: Output should be

       

      Cell 1 - Condition

      Cell 2 - Description of condition

      and so on