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
Bookmarks