|
A more generic solution, if you're still looking for one is to use the FIND function in conjunction the LEN, RIGHT, and LEFT functions.
The formula LEFT(cell,(FIND(" ",cell)-1)) will give you all the characters to the left of the first space in a cell (note the space in quotations).
The formula RIGHT(cell,(LEN(cell)-FIND(" ",cell))) will give you all the characters to the right of the first space in a cell.
While more complicated, these will work if the original list is not a fixed length (Subject codes may have different numbers of letters, or the course numbers may have more or fewer digits).
__________________
The secret to great marksmanship is deciding what the target was AFTER you've shot.
|