Modification of a VBA to extract 4-digit alpha only and 4-digit alpha+numerica mix values from cell string

  • [xpost][/xpost]

    Hello brainers,
    I have a VBA and this will extract all 4-digit numeric values from cell into next colums of the every row. Now I want 2 modifications in this VBA to extract 4-digit alpha value

    and 4-digit alphanumeric mix value. So in fact I want three types of data extraction:
    4-digit numeric (for which I have VBA below)

    4-digit alpha (for which I want VBA modification)
    4-digit alphanumeric (for which I want VBA modification)

    Here is VBA for extraction of 4-digit numeric only value,

  • Did you read the Forum Rules after your last warning? I suggest that you read them now!!!

    Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post

    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.

    How to use code tags

    Just highlight all of the code and press the <> in the post menu above button to add the code tags.


  • Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the URL from the address bar in your browser) to the cross-post. We are here to help so help us help you!

    Read this to understand why we ask you to do this

Participate now!

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