Hi there,
I'm having trouble trying to split out specific text in a longer text string. So, in the example below, Column B requires a formula to state either East, North, South or West, depending on what is entered in column A (as highlighted in red). I have a long list of data in column A and it is all uniform as can be seen that the text string starts with the same length of characters every time and so should make it possible to have the one formula.
Any assistance would be gratefully received as the data set is large!
Regards
Ben
I'm having trouble trying to split out specific text in a longer text string. So, in the example below, Column B requires a formula to state either East, North, South or West, depending on what is entered in column A (as highlighted in red). I have a long list of data in column A and it is all uniform as can be seen that the text string starts with the same length of characters every time and so should make it possible to have the one formula.
Any assistance would be gratefully received as the data set is large!
Regards
Ben
A | B | |
1 | Location | Block Name |
2 | RainH TC | East B | 00 | 3005 | English Classroom | East |
3 | RainH TC | North B | 00 | 1062 | Mat Store | North |
4 | RainH TC | South B | 00 | 1001g | Corridor | South |
5 | RainH TC | West B | 00 | 1029 | SenCo | West |
6 | ||
7 |