Ben,

You can use the Split function to split the string into an array
of strings.

Dim S As String
Dim Arr As Variant
Dim N As Integer
S = ".00004,.00034,.0024,.008"
Arr = Split(S, ",")
For N = LBound(Arr) To UBound(Arr)
Debug.Print Arr(N)
Next N



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Ben H" wrote in message
...
Hi all! I need to take a string and seperate it into 4
strings. It reads
".00004,.00034,.0024,.008" and i need to put it into 4 seperate
strings,
seperated by the commas

Thanks!