Results 1 to 6 of 6

Help extracting single numbers

Threaded View

  1. #1
    Registered User
    Join Date
    10-15-2015
    Location
    Colchester, UK
    MS-Off Ver
    Windows 365
    Posts
    10

    Help extracting single numbers

    Hi I am trying to isolate single numbers (the numbers are size 6, 7, 8 and 9) and nothing else. The numbers I want have a space after if they have anything else I needs to be ignored
    I am using power query to try and achieve this
    Attachment 736502
    As you can see from the picture I have managed to get rid of the 1st 4 numbers (column B) but I need to isolate the single numbers (with a space afterwards)
    I want from 6 STND ... 6 as an example but from lets say 2XL AG ... I want it blank or null

    Hope this makes sense

    Thanks
    Kim
    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. Replies: 8
    Last Post: 05-20-2015, 10:25 AM
  2. extracting two different lists from a single one.
    By kipronopaul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2013, 05:11 PM
  3. extracting values from a single cell
    By zobufeja in forum Excel General
    Replies: 2
    Last Post: 08-01-2010, 11:44 AM
  4. Replies: 17
    Last Post: 03-03-2010, 06:55 PM
  5. [SOLVED] Extracting single piece of data
    By Louis in forum Excel General
    Replies: 7
    Last Post: 02-08-2006, 08:35 PM
  6. [SOLVED] RE: Extracting single piece of data
    By Ron Coderre in forum Excel General
    Replies: 0
    Last Post: 02-08-2006, 03:55 PM
  7. [SOLVED] RE: Extracting single piece of data
    By CLR in forum Excel General
    Replies: 0
    Last Post: 02-08-2006, 03:50 PM

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