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

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    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

  • royUK

    Closed the thread.