Closed Thread
Results 1 to 4 of 4

HELP. Remove multiple numbers (1-2 digit) from a text sentence.

  1. #1
    Registered User
    Join Date
    06-24-2009
    Location
    United states
    MS-Off Ver
    Excel 2007
    Posts
    6

    HELP. Remove multiple numbers (1-2 digit) from a text sentence.

    I need to remove 3 (one or two) digit numbers out of a sentence and keep them in some logical format.

    example (any of the three numeric areas could be single, double, or triple digits):
    Detected 3 words. understood 1 out of 6 letters.


    I only need the 1 and 6. I can't use MId because the number of characters will change depending on whether the first or second number in the cell is single double or triple digits.

    What do you think?

  2. #2
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256

    Re: HELP. Remove multiple numbers (1-2 digit) from a text sentence.

    Is there a consistent structure in each of the cells (and only the number of digits in a number changes?)
    "I don't know what I don't know"

  3. #3
    Registered User
    Join Date
    06-24-2009
    Location
    United states
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: HELP. Remove multiple numbers (1-2 digit) from a text sentence.

    It is the same text for each cell. Only the number of digits change for each of the three numeric sections of the text

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: HELP. Remove multiple numbers (1-2 digit) from a text sentence.

    This is really a duplicate post I think. Please continue on other thread...

    Thread Closed.

    http://www.excelforum.com/excel-prog...text-cell.html
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

Closed Thread

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