garyc
12-15-2008, 12:30 AM
can we get the data from a string of data with marks to separate the useful items
For exampe,
apple, banana, orange, melon,......
-->
turn into a spreadsheet in a column
Cell
A1: apple
A2: banana
A3: orange
A4: melon
Can we do this with VBA in excel ????????????????????
I just know I can use len() and left() and right() and find()
but I just can do the above process when the string just contain 2 items.
Thanks!
For exampe,
apple, banana, orange, melon,......
-->
turn into a spreadsheet in a column
Cell
A1: apple
A2: banana
A3: orange
A4: melon
Can we do this with VBA in excel ????????????????????
I just know I can use len() and left() and right() and find()
but I just can do the above process when the string just contain 2 items.
Thanks!