1 Reply Latest reply on Apr 6, 2017 2:18 AM by luffyfilemaker007

    Getting/Extracting text

    luffyfilemaker007

      Hi guys;

       

      So I have a text/number and I would like to extract only some characters in it.

      For example T451518001 I would like to extract only the 45 and on another field only extract the 18.

       

      I tried to Left/Right /Middle formula but this gets me characters that I dont want.

       

      Looking forward to your help.