Results 1 to 5 of 5

Copy just the order number from another Cell.

Threaded View

  1. #1
    Registered User
    Join Date
    04-21-2008
    Posts
    10

    Red face Copy just the order number from another Cell.

    I have a worksheet with multiple columns of data. Column "D" is basically a notes field. It has random notes, but also includes part numbers.

    Column D Example:
    Row 1: Customer needs new DS45678
    Row 2: A new DS983 is needed by Wednesday.

    What I need (want) to do is pull just the part numbers from "D" and copy them to "C".

    Is there a way to write a formula that will find "DS" and copy that and all numbers after it until the first "white space" (Row 2 example) or end of data (Row 1 example)?

    Example of what "C" should look like with the above example
    Row 1: DS45678
    Row 2: DS983

    Thanks in advance.
    Last edited by chamber12; 04-21-2008 at 12:55 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