Results 1 to 4 of 4

Thread: Extracting single numbers from a string

  1. #1
    Neophyte Bigdog's Avatar
    Join Date
    Oct 2018
    Posts
    2
    Articles
    0
    Excel Version
    2013

    Extracting single numbers from a string



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all, brand new here. Using Excel 2013.

    I need help with extracting single numbers from a string of numbers. I am using the Find function (Ctrl F) in a column of cells that each contain six numbers from 1 to 99, separated by commas, no spaces, i.e., (6,32,44,59,67,71). The issue I'm having is that while finding any number over 10 is easy, finding 1 through nine is difficult, as the function returns all 1's, 2's, etc., including those in the teens, twenties, thirties, etc. My work around has been to run the function, then physically count the single integers, which is time heavy to say the least.

    Can anyone give me a better solution, please?

    Bigdog

  2. #2
    Acolyte alansidman's Avatar
    Join Date
    Oct 2018
    Posts
    27
    Articles
    0
    Excel Version
    2016
    please provide a sample workbook that is representative of your actual file that can be analyzed and a solution provided.

  3. #3
    Neophyte Bigdog's Avatar
    Join Date
    Oct 2018
    Posts
    2
    Articles
    0
    Excel Version
    2013
    Well, it seems I found my own solution.

    By breaking out the string into individual cells (Data/Text to Columns), then Find/Match entire cell contents, I can eliminate the multiple hits on any number over ten.

    Thanks to those that read this post anyway.

    Bigdog

  4. #4
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,467
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Thanks for sharing your solution with the board
    Thank you Ken for this secure forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •