View Single Post
Old 11-10-2010, 09:17 AM   #7 (permalink)
GreyWolf
Sober
 
GreyWolf's Avatar
 
Location: Eastern Canada
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.
GreyWolf is offline  
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38