Help with MID Function?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi. I may not have explained myself well enough in my last post. So
here goes again.
I'm trying to capture / extract specific data within a string of text
in a cell. I need to capture a string of numeric characters plus only
the first alpha character immediately after the numbers. The numbers
of alpha characters varies before the numeric characters. So my cells
could look like this: TTTTT10TTTTTT or TTT1000TTTT or
TTTTTTT1TTTTTTTTTTTT etc.. My output from the cells would be 10T or
1000T or 1T etc... The text string before and after the number string
vary. Can this be done?



.

Relevant Pages

  • RE: Help with MID Function?
    ... Cells A1:I1 ... Public Function GetNumAndCharAs String ... Dim iRow, iCol, iposit, iStop As Integer ... I need to capture a string of numeric characters plus only ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help with MID Function?
    ... If you want to with a UDF as Ron has proposed, and if you are uncomfortable with Regular Expressions, here is a non-RegEx UDF for you to consider... ... Function GetNumberPlusOne(S As String) As String ... I need to capture a string of numeric characters plus only ... So my cells ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help with MID Function?
    ... I'm trying to capture / extract specific data within a string of text ... I need to capture a string of numeric characters plus only ... the first alpha character immediately after the numbers. ... So my cells ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Length of longest contiguous digits exercise
    ... this contiguous block of 1s is remembered ... string must not appear at any other point in the string. ... this is undefined when there is no capture ... (which happens when there are no digits in the ...
    (comp.lang.javascript)
  • Re: Regex Capture problem
    ... "learned" my regex using a freeware utility that had slightly different ... was trying to capture instead of. ... I have used Regex utilities before, so I understand the concepts of text ... Function RESub(str As String, SrchFor As String, ReplWith As String) As String ...
    (microsoft.public.excel.programming)