Hi,
In cell a1 I have the following text "45 students fail test 5 of report" ok so I want to remove test 5 from the cell so I used =subsitiution(a1,"test 5","") and this worked but my cell a1 the number of test keep changing from test 1 to test 2 all the way up top test 9, so all I want to do...