Custom Function coding

  • I have a custom function created to extract integers from a string. This initially worked fine when the strings consisted of a set format of text+integer. Now I have instances where the string consists of integers+text+integers but I only want to capture the first set of integers. I've copied the code for the function below and I'm looking for a way to modify so I can extract the first set of integers from the string.
    I've also attached a workbook as an example.

  • Based on the sample provided, either of the following functions should extract the leftmost number from the string, starting at position 1:

    The 2nd function uses the fact that all your samples contained the same "|" delimiter after the initial number.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!