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" wrote in
message ...

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