Extract numbers from string

[Av8tordude]

Label1 = Price: $0.00/yr

How can I extract "$0.00" from a label. I've tried Split(label1, "/") (0), but it returns "Price: $0.00"

 

[Joe4]

Label1 = Price: $0.00/yr

How can I extract "$0.00" from a label. I've tried Split(label1, "/") (0), but it returns "Price: $0.00"

Do they all follow this exact same format?
Please post a larger sample size showing the various different ways the data might look.

Also, are you trying to do this in an Excel formula or in VBA?

 

[Av8tordude]

Do they all follow this exact same format?
Please post a larger sample size showing the various different ways the data might look.

Also, are you trying to do this in an Excel formula or in VBA?

1. Yes..I only want the price e.g. 1.99
2. VBA only

 

[Av8tordude]

I tried the code below but can get the cents to appear

Int(Split(Replace(lbPrice, "/year", ""), "$")(1))

 

[Joe4]

For a value in "label1" like "Price: $0.00/yr", try this:

    Dim arr1() As String
    Dim arr2() As String
    
    arr1 = Split(label1, "$")
    arr2 = Split(arr1(1), "/")
    
    MsgBox arr2(0)

 

[Av8tordude]

Thank you Joe for your assistance and expertise

BTW...I modified it to...

Split(Split(Label1, "$")(1), "/")(0)

 

[Joe4]

Thank you Joe for your assistance and expertise

BTW...I modified it to...

Split(Split(Label1, "$")(1), "/")(0)

You are welcome.
Glad I was able to help.

Yep, you can combine it all to one line.
I often like to break it up over multiple lines for demonstration purposes so it can be more easily seen how it is working (sometimes it can be confusing, especially on longer formulas when everything is together on one long line).