How to fetch first few values or names from excel column

[meetvivek72]

is there any way by which we can extract first few names and display the same fetched data in another column.. Let us suppose we have a Column having 10 values in its cells. I want the first 8 to be displayed in another column, First 5 to be displayed in next column.....

[:) Sixthsense :)]

We can do it in many methods but for giving exact solution we need a sample workbook with expected result

[meetvivek72]

the whole issue is explained in comments section of the attached sheet

[:) Sixthsense :)]

It seems that you have lot of id's registered with this site and creating duplicate threads with the help of multiple user login(s)

Here is your original thread

http://www.excelforum.com/excel-gene...-in-excel.html

Can you please describe how this thread is differed from the above one?

Please don't waste the members time by way of duplicating the threads.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

[meetvivek72]

see that was almost the same problem ...but it was raised by my friend through his ID... The problem in that thread was explained in a clumsy way, so i tried to present it in a simple way through my ID.....

[Fotis1991]

Thread Closed.