Have a look in Help for Data | Text to Columns
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"Awaitingeyes" wrote in message
...
Hay Guys
is there any formula or way in excell to make following series seperate?
please guys if any one know pl inform
Start Range End Range QTY
03003724061 03003724069 1