Dear All,

Please find below problem description,

if A1 cell a contains "BFH" string, it should return last 20 characters of A1 in cell D1
if cell A1 contains BFH string , Cell E1 should return first 12 strings of B3
If cell A1 contains BFH string, Cell E1 should return value of B4

Kindly suggest me the solution

Regards

Vishwa