se SPLIT Function:

Sub test()


Dim v As Variant, i As Long
v = Split("A,B,C,D", ",") ' String is "A,B,C,D" with delimeter of ","
For i = 0 To UBound(v)
MsgBox v(i)
Next
End
End Sub

HTH

"Shashi Bhosale" wrote:

I have a string variable with values comma seperated ,
How to i read each value in Excel using vb code.