in VBA the Split function will split the string on commas into a zero-based
array

Dim MyList() As String

MyList = Split("Damage,Scratch,F-F,In-Ops", ",")

For i = 0 To UBound(MyList)
Debug.Print MyList(i)
Next i



"vqthomf" wrote:

Hi I am trying to separate word from a text string Damage,Scratch,F-F,In-Ops
into variables I have tried The Mid Function with Instr, but I am finding it
most difficult.
Can anybody help me please Thanks
Charles