"CUT" rest of cell after first number

I have about 10,000 rows of product descriptions that I need to split. I don't want to cut and paste all 10,000 of those. Here is an example of how they look now(all in one column and I added red to show what I want to CUT):

BTR KRNL CREAM CORN 15Z
BTR KRNL CUT GR BEANS 15Z
BTR KRNL F S GRN BEAN 15Z
BTR KRNL SWT PEAS 15Z
BTR KRNL WK CORN 15Z
CAMP DRY DBL NDL 3.6 OZ
CHORE BOY HD SC SPNG 1 PK
FRENCH WORCESTERSHIRE 5 Z
O F TOMATO PASTE 6 OZ
OF DICED POTATOES 15 OZ
OF DISTILLED WATER 128Z
OF DRINKING WATER 128Z
OF LEMON GELATIN 3 OZ

I would like to cut the text in red and paste into the next column over. Is there an easy way to do that?

Something like:
--find the first digit in the cell and select that and everything to the right in that cell

--then cut and paste that in the next column

I am open to any suggestions, thanks

Try:

=RIGHT(A1,LEN(A1)-MIN(FIND(0,SUBSTITUTE(A1,{1,2,3,4,5,6,7,8,9},0)&0))+1)

where A1 contains original text

If you want to do that, you can add another column...

=Substitute(A1,B1,"")

where A1 contains original and B1 contains the number cut out...

then you can copy and Edit|Paste Special >> Values over the original and delete this helper.