4 Replies Latest reply: May 2, 2018 11:50 AM by patrico mesri RSS

    New field bases on specific value in cell/text

    patrico mesri

      Hi community.

       

      I need to do a new field on the load tab with the following data:

       

      Name
      asdaddsaDONT USE
      asdDONT USEasd
      DONT USEasdsasd
      asdsaddadasdsadsa
      asddsadsad
      asd(DONT USE!)asddas
      OPENasdasd
      asddsaOPENasdsad

       

      The fields I need would be "Name DONT USE" and "Name Open".

      If the words DONT USE or OPEN would be at the beggining or the end I would use =RIGHT or =LEFT but it is not the case.

      I have tried using if(wildmatch)) but I'm not doing it correctly.

       

      Any help would be appreciate.

       

      Thank you in advance.

      Regards.