Instr([Table1].[test]," T/A") gets the index of [Table1].[test] string where T/A starts

Right([Table1].[test],Instr([Table1].[test],"T/A")-2) should get the content of the field after T/A

If it does not for any case put that string.