Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to split a string and return array
VBA code question: how can I use split function to break a string and then retun th results to array? for example: a string: Prince William, Manassas + Manassa 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 buildin Myarray. since the string will change, the upperbound of Myarray will chang also. any help or idea will be appreciated!! thanks for any respons -- xian ----------------------------------------------------------------------- xiang's Profile: http://www.excelforum.com/member.php...fo&userid=2948 View this thread: http://www.excelforum.com/showthread.php?threadid=49333 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to split a string and return array
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split text string using mid-search? | Excel Discussion (Misc queries) | |||
split string based on a SET of words | Excel Discussion (Misc queries) | |||
Solve operators within a string...split? | Excel Programming | |||
Passing a String in Array to Range as String | Excel Programming | |||
Return string array from function in excel 97 | Excel Programming |