Finding Specific Letter and Number Strings

[jpedges38]

Say I have these two lines in Column A:

3051S2TG4A2A11X5AWA3WK1I5A1140
3051S2LD2AA1A1030DFF71CA00


I need to be able to have a formula in Column B that Finds the letter "A" when it is followed by four numbers, and then return "A and the 4 numbers."

So for the first line, the result in Column B would be "A1140," and the second line result would be "A1030"

Any help would be much appreciated.

Thanks,
J

 

[pgc01]

P. S.

You can also use the Reset in the VBEditor in the Run menu.

 

[mps12345]

Thanks again for your time.

 

[pgc01]

You're welcome. Thanks for the feedback.

... but I could not find anything similar to this on the site. ...

Here's a small introduction to Regular Expressions:

Regular expressions - An introduction