Results 1 to 7 of 7

Extracting numbers from text

Threaded View

  1. #1
    Registered User
    Join Date
    02-09-2009
    Location
    Winnipeg, Canada
    MS-Off Ver
    Excel 2003
    Posts
    49

    Extracting numbers from text

    See attached file for example.
    I need to separate text information from a cell into 3 columns (W,9-8). The first letter I know how to extract. The problem is to extract the number in the middle (1 or 2 digit) between "," and "-" and also the last number. For the last number I could use right() function but the problem is that number could be 1 or 2 digits so I can not specify in advance so formula would have to extract the last number till "-". Anyone knows how to do this?
    Attached Files Attached Files
    Last edited by bmind; 06-15-2009 at 12:00 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