Results 1 to 5 of 5

"CUT" rest of cell after first number

Threaded View

  1. #1
    Registered User
    Join Date
    08-27-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    12

    "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
    Last edited by deluxe01; 09-01-2009 at 03:23 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1