Hi,
I am trying to isolate string after the last space for each test, the formula I have used works for the first 2 tests but not the third, why is this?
I am trying to isolate string after the last space for each test, the formula I have used works for the first 2 tests but not the third, why is this?
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | TEST1 TEST2 TEST3 TEST4 | TEST4 | ||
2 | NOTEST1 NOTEST2 NOTEST3 NOTEST4 | NOTEST4 | ||
3 | JFIE AOIEJFJ AOSFE AFEJI | OSFE AFEJI | ||
Sheet1 |