5 Replies Latest reply: Oct 13, 2014 6:18 AM by Marcus Sommer RSS

    Split out a word from a long text - one of several

    Friedrich Hofmann

      Hi,

       

      in the Excel_file I'm currently working on:

      - There is a field named "comments" where the customer can enter whatever and as much as they want;

      - In that field, there might or might not be any of the words "A-Service", "B-Service", C-Service", "DGR" or "Flash".

       

      => I can use the INDEX() function to look for the word "Service" and then use the MID() function to single out the full word.

      <=> How about the others? How can I pass several words to the INDEX() function?

       

      Thanks a lot!

      Best regards,

       

      DataNibbler