VBA to extract string between 2 special characters (where spec. characters appear twice)

[Sah213]

I'm looking for some VBA to extract the text: 1620011017 from the below string;

Inv_1620056384_1620011017_1034258

There could be any number of characters, so I think I would need to define it based on the fact it's the string between the 2 underscores.
I think starting from the right of the string would be easiest as starting from the left it's the 2nd string between the _ characters. Starting from the right, it's the first string that meets that criteria.

If anyone could help with their expertise, I'd really appreciate it!

 

[Marc L]

​

Hey Joe why a formula - static - while the initial post requires « some VBA » ?!​

 

[Joe4]

Sorry, missed the part about VBA.

 

[Marc L]

​

Can be useful if its VBA procedure reads your formula result from a cell …​

 

[Sah213]

A VBA demonstration as a beginner starter :​

Sub Demo1()
    V = Split("Inv_1620056384_1620011017_1034258", "_")
    If UBound(V) > 1 Then MsgBox V(2)
End Sub

This works really well thanks!

 

[Sah213]

Sorry, missed the part about VBA.

No worries - Marc L's solution works great. Thanks all!

 

[Marc L]

​

Thanks !​

​

Post #4 is from the left and the post #6 variation is from the right …​