Results 1 to 20 of 20

Extract Digits with relevant characters

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Extract Digits with relevant characters

    Hi,

    I have a list (col. Q) of items incl. other parameters - such as:

    18 Kg Cement
    7/32" Screw
    Wooden board board 4.5"/5.5"
    12.34 meters wire

    In general I'm looking for a Sheet Formula (no UDF - which I already wrote) in order to extract the Numeric Digits(0,1,2,3,4,5,6,7,8,9) AND all relevant characters.

    Requested returns:
    18
    7/32"
    45"/5.5"
    12.34

    In fact I would like to extract CHAR(35) up to CHAR(64)

    What will be the formula to achieve that ?

    Thanks, Elm
    Last edited by ElmerS; 03-03-2010 at 04:31 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