Splitting text from a cell

[NBBingo1858]

Hi All,
I would like to separate the data in this cell - having the numeric value (with the letter class) in one column and the text (description) in another column. If I do a =LEFT(A2,9) I can extract the number and letter class, I am just a little stuck in getting the rest of the text into another column. Could I ask for a little help please.
Support page
Here is an example - 111120a - (PRP) Oilseed (except Soybean) Farming

[#2 · Accepted solution]

@NBBingo1858 If you always want the 2nd column to contain everything except the first 9 characters use this:

=RIGHT(A2),LEN(A2)-9)

[#3]

@Riny_van_Eekelen 

Thanks for this. But I keep getting this error message

[#4]

missing bracket. =RIGHT(A2),LEN(A2)-9) should be =RIGHT((A2),LEN(A2)-9) now it works. Many thanks for the formula though.

[#5]

@NBBingo1858 Oooops. Actually, one bracket too many.

=RIGHT(A2,LEN(A2)-9)