Results 1 to 10 of 10

Extract String After Specific Word

Threaded View

Gingeiko Extract String After Specific... 12-02-2011, 01:58 AM
nilem Re: Extract String After... 12-02-2011, 02:47 AM
Gingeiko Re: Extract String After... 12-02-2011, 03:10 AM
Gingeiko Re: Extract String After... 12-02-2011, 03:23 AM
pike Re: Extract String After... 12-02-2011, 04:24 AM
Gingeiko Re: Extract String After... 12-03-2011, 06:23 AM
DonkeyOte Re: Extract String After... 12-03-2011, 07:02 AM
pike Re: Extract String After... 12-03-2011, 07:27 AM
nilem Re: Extract String After... 12-03-2011, 07:50 AM
Gingeiko Re: Extract String After... 12-03-2011, 09:05 AM
  1. #1
    Registered User
    Join Date
    11-28-2011
    Location
    Singapore, Singapore
    MS-Off Ver
    Excel 2007
    Posts
    19

    Extract String After Specific Word

    Hi,

    I have a report of 20000+ rows. I need to extract certain data from one of the column. For the example below, I need to extract the 9 digits that comes after 'SN#'.

    May I know if this is possible, given the complexity of the data..

    [6 rows under same column]:
    [R1]Record - DN No. 98765421 SO# 1343434 for CUSROMER 1 - SN# - 07/29/2011'
    [R2]Record - DN No. 12345677 SO# 1222222 for CUSTOMER 2 - SN# - 07/29/
    [R3]Hardness Test Results SN# - SN# 133449982-1, PO , HEAT# - 07/29/2011'
    [R4]Inspection for Main Part SN# - SN# 123456098-1 TO 4, PO , HEAT# - 07/29/2011'
    [R5]Dimensional for Main Part SN# - SN# 119221033, PO# HN# - 07/29/2011'
    [R6]Dimensional for Sub Part SN# - SN# 120012999-1 TO 5, PO# HN# - 07/29/2011'

    I should be getting in another column:
    [R1]
    [R2]
    [R3] 133449982
    [R4] 123456098
    [R5] 119221033
    [R6] 120012999
    Last edited by Gingeiko; 12-03-2011 at 09:12 AM.

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