Dear Hussain, Use Text to Column under Data Menu
1. Highlight the source data 2. Run Data | Text to Columns and choose Delimited, click next 3. choose Space as delimiter then click Next 4. Click Finish Finally you'll have the numbers separated and reside a cell each. good luck On 4/10/14, [email protected] <[email protected]> wrote: > Dear Group Members, > > I need to split down from Column to Every "002262" in Individual Column > > > Regards, > > > Maqbool Hussain >
