hey all

is it possible to strip each item from the below string and then place each item into a separate cell?

ie. I have a cell content such as:

U 25 Stewart, Patrick, A 100.64 0.00 123.35 0.00 0.00 0.00 25000.00 3555.01- 290.33

and would like to place each item into ajoining cells in a row (the name can be taken as one long string)

thanks

Hi

You could use split to split your data up e.g
******
X = Split(URStringvar, " ")
myVar = X(0)
********
If you look at the obove piece..URStringvar is the variable containing your string. MyVar will be the value to insert in the cells where 0 would take the first part up to the space, if you change 0 to 1 it will take the second part after the space.

You will have to build some "counting logic" into your program to get "U 25 Stewart, Patric, A" into one cell. So maybe only get the data for 5 splits and contanate, insert, and then do the rest in a seperate cell.

Hope this helps, let me know if you need assitance with the logic to get the name in one cell.

Regards
Marnus