Hi
one way:

Sub foo()
Dim Text_Split As Variant
Text_Split= Split(ActiveCell.Value)
MsgBox Text_Split(0)
MsgBox Text_Split(1)
End Sub



--
Regards
Frank Kabel
Frankfurt, Germany

TAM wrote:
I am trying to use the split function to return several instances of
substrings within a string. Can you please tell me how to return
those
values e.g. to a variable

Thanks

TAM