Formula to separate text from alpha numeric codes

Hi all,

I have a list of data that includes the "Training Subject" and the Training Code" in the same cell and I would like an easy to separate them - workbook attached

Sample:

Please Login or Register  to view this content.

Thanks

In B1 enter:

=TRIM(SUBSTITUTE(A1,C1,""))

in C1 enter:

=IF(ISNUMBER(FIND("OBC",A1)),"OBC ","")&TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255))

each copied down.

In some cases you have a number preceded by OBC, I assumed that was part of the code to extract with the above formulas....

If not right, just use =TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),255)) for C1 copied down.