Strip data from cell

[amerifax]

I have a cell with the following"
2 872102 - ACCOUNTING & BOOKKEEPING GENERAL SVC
15+ 651202 - OFFICE BUILDINGS & PARKS
15+ 753801 - AUTOMOBILE REPAIRING & SERVICE

The zeros after the 2 are not consistent, anywhere from 2 to 5 zeros.
I'm trying to strip out the description number, which is 872102 and also the description. I am able to strip out the description using the following:
=RIGHT(Q31,LEN(Q31)-SEARCH(" - ",Q31)-2)

I have tried many ways to strip out the description number with no luck.
872102

I was hoping to be able to strip them both out to the appropriate column:
P. description number
Q. description

I have been able to strip out the 2 that can be at times, a 1,2 or 3 character value such as 15+. Here I was able to use =Left(Q2,3)
Thanks

 

[shadow12345]

I put your example in A1

This formula in b1 gets the description number
=MID(A1,FIND(" ",A1,1)+1,6)

This formula in c1 gets the description
=MID(A1,FIND("- ",A1,1)+2,99)

Hope that helps...


(I assumed the description number is always after the first space and the description is always after the -)

 

[amerifax]

Description worked perfect.

Item Number was not working well. I should have mentioned that " - " is very consistent.
I have done the following to make it work.my concern is I'm doing it where it won't come back to haunt me in the future. I believe I have followed your lead, and converted the -6,6 appropriately
=MID(R2,FIND(" -",R2,1)-6,6)

Thanks again for your excellent and prompt help