| 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 |
| 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 | |||
![xiang[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
