Results 1 to 4 of 4

Thread: Remove only numeric value in the end of any string

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 04-02-2012, 09:17 AM #1
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Here is another formula that you can use...

    =LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"012345 6789"))-1)

    NOTE: There appears to be a space in the list of digits in both my formula and the one Admin posted... there is no actual space in that text... for some reason, the text processor for this forum seems to randomly insert them for display only... if you copy/paste the formula, those spaces will not be copied (mainly because they are not really there).
    Last edited by Rick Rothstein; 04-02-2012 at 09:22 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Solve Block If Without End If Problem
    By jffryjsphbyn in forum Excel Help
    Replies: 3
    Last Post: 06-12-2013, 11:06 AM
  2. Remove Special Characters From Text Or Remove Numbers From Text
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 5
    Last Post: 05-31-2013, 04:43 PM
  3. VBA - Find Last End Value
    By ivandgreat in forum Excel Help
    Replies: 3
    Last Post: 05-02-2013, 10:37 AM
  4. Start & End Number Further Converted
    By ayazgreat in forum Excel Help
    Replies: 32
    Last Post: 05-06-2012, 11:39 PM
  5. Lookup Multi-Column For Unique String Combination For Numeric Value Output
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 07-03-2011, 07:23 PM

Tags for this Thread

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
  •  

Forum Rules