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

      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.

       

      Best,


      Rubens Rodrigues.