Im trying to create a template in which an sdf file will be dropped into my spreadsheet, there will be anywhere between 2000 and 50000 strings of data droped in to the sheet which look like this

1,33,52,47,0,0,3
2,36,55,47,0,2,0
3,38,53,47,0,0,0
4,39,52,47,0,0,0

once the data is dropped in i need it to seperate every value into a new cell so it appears like this

1| 33| 52| 47| 0| 0| 3|
ect

i know that i can use the data tab once i have the data in there but i need to know how i can set it up so that i dont have to touch anything when the data is dropped in, is there a formula in which u can use this process so that it will automatically do it once there is data in the sheet?

the second thing is i need to know a way of reading how many lines of data are bieng input so that the outcomes at the end will no have to be in a static location.... any ideas plz

Supposing that the value in A1 is 1,33,52,47,0,0,3

Do the formula;
- in A2
=LEFT(A1,1)
- in A3
=MID(A1,3,2)
- in A4
=MID(A1,6,2)

So on and so forth.

Another way is to use the Text-to-Columns feature and use comma as your delimited text.

I'm quite confused with your 2nd question....