luffyfilemaker007

Getting/Extracting text

Discussion created by luffyfilemaker007 on Apr 6, 2017
Latest reply on Apr 6, 2017 by 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.

Outcomes