Results 1 to 6 of 6

Searching for a numbers from right within a text string

Threaded View

  1. #1
    Registered User
    Join Date
    02-21-2014
    Location
    asia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Searching for a numbers from right within a text string

    Hi, I have a list of notes that contain text and numbers within a cell. I need a formula if possible that searches from the right of the cell and then returns the all the numbers.

    e.g.

    1.Inter 2. Juventus 3. R0ma 4.Cagliari formula result 4
    3. Politics;5 National, 7. Biology formula result 7
    19geographic formula result 19

    attachment
    data.xls

    The Result is extract a numbers within text cell from right.
    I can not use text to columns as they data is not consistant.

    Also worth noting is that the notes vary from 1 digit to 9 digits long.

    Any help would be great
    Last edited by don manual; 02-22-2014 at 08:40 PM. Reason: add attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Searching for text in a string
    By Jedski in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-10-2012, 03:44 PM
  2. VBA Vlookup error when searching for all numbers as a string, works fine with letters
    By thumpernc24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-23-2012, 10:06 AM
  3. Searching for text string
    By wit2001large in forum Excel General
    Replies: 6
    Last Post: 02-10-2011, 10:25 AM
  4. Searching for data string in list of numbers
    By Sweetypie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2010, 09:38 PM

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