Formula Help - Numeric Alpha Combination

[miggy999]

Hi All,

I really would appreciate some help with a formula.

I am trying to extract 4 characters which will be sitting together in a string, however, the particular 4 characters I am looking for will be sitting as a NUMBER/LETTER/LETTER/NUMBER.

For example, from the string below I am trying to get 4LA6 as the answer.
[TABLE="width: 276"]
<tbody>[TR]
[TD]LF-074LA6150-GB43602[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

If it is relevant there can be dashes anywhere in the string (but never between any of the 4 characters), and the numbers can be zero.

Can anyone help?

 

[István Hirsch]

Hi FormR,

You are correct, I wanted to mean the VBA. Thanks.