VBA to split and extract a cell

[Rinse04]

Hi guys, is it possible to extract the nth string between commas?
For example

Cell contents:"hello,how are you,I'm Great,today"

Say I want to extract the string in between the 3rd set of commas, "I'm Great". Is that possible with VBA?

Thanks in advance.

 

[Georgiboy]

Maybe:

Sub test()
    Dim strVar As Variant

    strVar = Split(Range("A1").Value, ",")
    
    MsgBox strVar(2)
End Sub

 

[Phuoc]

Try this

Public Function Extract_nth(ByVal s As String, n As Long) As String
    Extract_nth = Split(s, ",")(n - 1)
End Function

Using:

=Extract_nth(A1,3)

 

[Rinse04]

Great, thank you

 

[Phuoc]

You're welcome!