Hi,

I have set of formula/formulas for extracting particular data sting from the data set. However i require help in applying multiple formula basis of string contained in data set for extraction.

```
Data Set > Contains string > Formula 1+Formula 2 > Result
```

A1 > ABC/23902983109/ASDJCNKS@YD (Data set) > ABC(String) > IF(SEARCHB(“ABC/”,A1,1),“ABC”) - Formula > ABC (End Result)

A2 > MB/NEFT DR/XYZ/SDSDC098098/DD > NEFT DR(sting) > IF(SEARCHB("/NEFT DR/",A2,1),MID(A2,12,100)) + LEFT(A2,FIND("/",A2)-1) > XYZ(End Result)

A3 > DCSD CHARGES > CHARGES(String) > IF(SEARCHB(“Charges”,A3,1),“Charges”) > Charges (End Result).