John Yazou
New Member
- Joined
- Mar 17, 2002
- Messages
- 49
Hi guys,
Am sure you guys can figure this out..
I have a string, which the # of comma delimited items varies..
eg. strLineBuffer = "A, B, C, D"
Is there some kind of function in excel vba that takes the string, and takes each word delimited with a comma and puts it in an array.
eg. MagicFunc (strLineBuffer)
returns an array that contains "A", "B", "C", "D"
Thanks...
Am sure you guys can figure this out..
I have a string, which the # of comma delimited items varies..
eg. strLineBuffer = "A, B, C, D"
Is there some kind of function in excel vba that takes the string, and takes each word delimited with a comma and puts it in an array.
eg. MagicFunc (strLineBuffer)
returns an array that contains "A", "B", "C", "D"
Thanks...