how to split a string and return array

[xiang]

VBA code question:
how can I use split function to break a string and then retun the results to array?

for example：
a string： Prince William, Manassas + Manassas Park,[51942]
separator：comma ， and plus sign +
results would be something like :
Myarray = (Prince William, Manassas, Manassas Park,[51942])
I think I have to Trim each element in Myarray before building Myarray.

since the string will change, the upperbound of Myarray will change also.

any help or idea will be appreciated!!
thanks for any response

[Bob Phillips]

Dim sTest As String
Dim aParts
sTest = "Prince William, Manassas + Manassas Park,[5192]"
aParts = Split(Replace(sTest, "+", ","), ",")


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"xiang" <[email protected]> wrote in
message news:[email protected]...
>
> VBA code question:
> how can I use split function to break a string and then retun the
> results to array?
>
> for example：
> a string： Prince William, Manassas + Manassas
> Park,[51942]
> separator：comma ， and plus sign +
> results would be something like :
> Myarray = (Prince William, Manassas, Manassas Park,[51942])
> I think I have to Trim each element in Myarray before building
> Myarray.
>
> since the string will change, the upperbound of Myarray will change
> also.
>
> any help or idea will be appreciated!!
> thanks for any response
>
>
> --
> xiang
> ------------------------------------------------------------------------
> xiang's Profile:
http://www.excelforum.com/member.php...o&userid=29489
> View this thread: http://www.excelforum.com/showthread...hreadid=493338
>