+ Reply to Thread
Results 1 to 9 of 9

Return only numbers directly after specific substring

Hybrid View

  1. #1
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Return only numbers directly after specific substring

    With a UDF

    Function NumAftRX(rData As Range) As Double
    Dim item As String, st As Integer, num As Long
    item = rData.Value
    st = InStr(item, "RX") + 2
    For x = st To Len(item)
        If IsNumeric(Mid(item, x, 1)) Then num = num & Mid(item, x, 1)
    Next
    NumAftRX = num
    End Function
    Kind regards
    Leo
    Attached Files Attached Files

+ 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. [SOLVED] Search substring and return adjacent value
    By uberathlete in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-02-2015, 07:06 PM
  2. Match Substring to another column and return value
    By JLeague in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-24-2015, 03:34 PM
  3. Add substring to specific conditions
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2015, 05:08 AM
  4. Replies: 3
    Last Post: 09-07-2014, 12:25 AM
  5. If contains specific numbers then return a sum.....
    By Kesa Anne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2013, 02:01 PM
  6. Search string for substring...return match
    By Gambinus in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-21-2012, 03:18 PM
  7. Searching a String for a Specific Substring
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 04:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1