Results 1 to 4 of 4

extract numberic database from long string value depends upon index value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    extract numberic database from long string value depends upon index value

    Dear experts

    I have alphanumberic long string in cell and want to pull the numeric value from cell depend upon header Dead or killed and injured or wounded
    whereas come along with text string in cell.

    The 2001 HaSharon Mall suicide bombing in Netanya, Israel. 5 killed 100+ injured. pull like (5 killed) and (100+ Injured)
    2002 Jaffa Street bombing. 1 dead,23 Wounded Pull like (1 dead) and (23 wounded)

    find the attachmen
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract values from long string
    By s@skia in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-13-2014, 12:32 PM
  2. what formula to extract text from a long string?
    By SEMMatt in forum Excel General
    Replies: 5
    Last Post: 10-07-2012, 10:23 PM
  3. Extract only numberic values from a cell
    By tferrence in forum Excel General
    Replies: 3
    Last Post: 08-11-2008, 12:35 PM
  4. [SOLVED] Extract specific value from a long text string
    By Dinesh in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-10-2006, 11:30 PM
  5. Extract sub-string of number from field of long series of numbers
    By ExcelExtrator in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-27-2005, 07:00 PM
  6. Excel Database Query String Too Long
    By Karl Burrows in forum Excel General
    Replies: 4
    Last Post: 01-27-2005, 03:06 AM
  7. Excel Database Query String Too Long
    By Karl Burrows in forum Excel General
    Replies: 4
    Last Post: 01-27-2005, 03:06 AM
  8. [SOLVED] Excel Database Query String Too Long
    By Karl Burrows in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2005, 03:06 AM

Tags for this Thread

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