+ Reply to Thread
Results 1 to 3 of 3

Stripping Numbers from Text String.

  1. #1
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Stripping Numbers from Text String.

    Hi All

    I am using this Function in my Sub:

    Please Login or Register  to view this content.
    It Strips the Numbers From a String BUT only when the String is in the format of Example : STP001 It would give me : STP

    This is Great and works fine BUT

    What if my String was STP001V I would like the result to be also : STP but because it has Letters on the end the Function Returns : ""

    Any Ideas how i can Modify this Part:

    Please Login or Register  to view this content.
    Any Help is greatly appreciated.

    Regards

    JRidge

  2. #2
    Forum Contributor
    Join Date
    06-04-2013
    Location
    Moscow
    MS-Off Ver
    Office 365
    Posts
    100

    Re: Stripping Numbers from Text String.

    Please Login or Register  to view this content.
    I'm sorry my english...

  3. #3
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    265

    Re: Stripping Numbers from Text String.

    Thank You The_Prist

    Works Great
    If the solutions provided within this Thread takes care of your question:

    Please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

    You can also click on * (star) Add Reputation to add reputation to those who have put their time and efforts to help you in this Thread.

    This is another way to say Thank You to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 03-07-2009, 05:40 PM
  2. Stripping Letters from Numbers
    By luke.thomas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2007, 03:28 PM
  3. Stripping the Last Field From a URL String
    By chasfh in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-30-2007, 09:04 AM
  4. [SOLVED] adding cells after stripping numbers out of text fields
    By Alan in forum Excel General
    Replies: 1
    Last Post: 08-24-2005, 04:05 PM
  5. Replies: 10
    Last Post: 05-23-2005, 03:06 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