How do I sort column with mixed letters and digits?

Hi guys! I have a datasheet and there is a row with mixed digits and letters.. It looks like this:
55J 85 BU5990
55K 23 BU5999
30K 99 BU7909
908 8 JO6540
2387 LOOI BU2345
981J 09I JO764
and so on...

How can I get Excel to sort only the BU and JO? I mean, I want Excel to ignore whatever is infront of BU and JO because that is not important.
And the BU and JO can vary between 3 digits to 9 digits. I want to sort this so it starts with the loest digits after BU and JO..

How do I do this? I am a beginner to Excel. So please help me out here. Is this even possible? So whatever is infront of BU and JO should be ignored, and only sort after what is after BU and JO...

Does this make any sense for you?

I cut out a small part of the workbook, since it all the same.Sheet.xlsx

Can anyone help me out here?

Hi,

Im pretty sure I have done what you are asking for. I havent gone through to make sure the items were sorted properly, but i will trust excels sorting capabilities. So first what i did was highlight the data you provided then went up to the data tab and clicked on "Text to Columns". After doing this you select what criteria you would like to separate your data by. In this case i separated by spaces. This gave me 3 columns, one of which has the BUs and the JOs. Next i highlighted all 3 columns of data and i went to the custom sort option under sort & filter in the home tab. Then you choose what column to sort by and by what criteria. I sorted on column L and by values. it also has a box to choose what order to sort in. Choose custom list and add BU and JO. this will sort the numbers behind BU then JO. To finish i used the concatenate function entered as follows =concatenate(J1," ",K1," ",L1) then copy down. I put two spaces between the quotes to keep about the same amount of space between numbers as the original. One thing i did notice is that the numbers following BU and JO are sorted in ascending order by individual place rather than as a whole.

It comes out something like this
BU2114
BU231
BU2331

What I think youre looking for
BU231
BU2114
BU2331

However I am not sure how to work around that part. Heres the file i worked on.

Awesome, this is exactly what I want.Thanks alot, this makes it alot easier for me. Thanks!

Enter into I1 with Ctrl+Shift+Enter and copy down:

=-LOOKUP(0,-MID(REPLACE(H1,1,MIN(FIND({" BU"," JO"},H1&" BU JO")),""),3,{1,2,3,4,5,6,7,8,9}))-IF(LEFT(REPLACE(H1,1,MIN(FIND({" BU"," JO"},H1&" BU JO")),""),2)="BU",10^10,0)

Then select columns I and J and sort them according to column J from Smallest to Largest.

If you do not need what is in front of BU or JO, enter into K1 and copy down:

=REPLACE(H1,1,MIN(FIND({" BU"," JO"},H1&" BU JO")),"")

If your Excel version works with „;” as an argument separator, substitute each comma in the formulas with „;”.