neelesh2003
New Member
- Joined
- Sep 30, 2010
- Messages
- 7
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 is remove test #, so I tried the following formula and it didn't work.
=subsitution(a1,"test #","") this not not working and it is driving me bonkers, how do I write this formula so I can remove the test and number after test,
Ahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh!
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 is remove test #, so I tried the following formula and it didn't work.
=subsitution(a1,"test #","") this not not working and it is driving me bonkers, how do I write this formula so I can remove the test and number after test,
Ahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh!
Last edited: