thank you for your reply. but i got problem. i have tried this. for example if i have item in the list box which has got different whitespace...
item1 5 4.5
item2 4 2.00
some thing like this, so there is no fix whitespace in between. hope i explained properly.
Not really, I see no differenct between item 1 and 2. However, if split does not work for you and your example is an actual representation of your data, then you could use the Left Function, Mid Function, Trim Function, Right Function, and (etc. on string functions) to pull it apart manually.