Nowhere in your descriptions have you mentioned to generate a list of numbers and so it appears that you wanted the list in Column A re-arranged, swapping the middle x numbers for the last y digits and vise versa, which could have been done with either VBA or a formula, probably simpler with VBA
When asking questions you have to assume that we know nothing of your problem or your business.
Explain the question as you would to a totally naive person
HUI
i respect your opinion and expertise, some time mind did not match but any how you all of providing good solution and doing great job for people like me..
Dear Narayan brother
need your expertise once again..need one formation more 1110111,2220222,3330333 so on and 1112111,2221222,3331333 so on , in same prefix
Nabeel
Some of them have been incorporated , but the others are in a different pattern. Please start a new thread for this. I am not in a position to reply for at least a week.