7 Replies Latest reply: Dec 10, 2014 2:56 PM by Marco Wedel RSS

    Character Functions: Take a piece of a text

    Rubens Rodrigues

      Hi folks,


      I wonder if you can help me with this chalenge!


      I have the following cell from a excel sheet:



      Unit A - CLA_99999 - Financial

      Uinit B1 - CLA_88888 - Controlership

      Unit B2 - CLA_77777 - Human Resources


      What I need is to take the piece of information that start with 'CLA_*', but as this is a unique cell with 3 line breaks, I don't know how to take the three 'CLA_ (CLA_99999, CLA_88888 and CLA_77777) from this full string and discard the rest.


      I appreciate any help in advance.



      Rubens Rodrigues.