excel copy and pasteSolved/Closed

Question

Hello, 
I have been given a list of 200 codes but they are in the wrong order. for example it goes 12378945610. so i want to swap the 456 and the 789 rows around, and i want to do this for the whole document. can this be done by a code? or will it have to be done manually.

Thanks



Configuration: Windows 7 / Firefox 3.6.12

RayH · Answer

Are the codes always in position 4,5 and 6 and 7, 8 and 9?

GeorgeAWSOME · Answer

This is the first 12 codes of the list and I want to swap the ones with a * with the ones with a #.  then next 12 will have the same format.

UPMUG 18000101MISCUS
UPMUG 18000101MUSFUS
UPMUG 18000101MGSFUS
UPMUG 18000101MGCFUS*
UPMUG 18000101MSCFUS*
UPMUG 18000101MSUFUS*
UPMUG 18000101MENFUS#
UPMUG 18000101MSEFUS#
UPMUG 18000101MGIFUS#
UPMUG 18000101MSCFUS
UPMUG 18000101MGUJUS
UPMUG 18000101MSUJUS

RayH · Answer

So, what is the intended outcome?
 I'm assuming that the * and # are just being used to highlight the rows. 
It looks to me that the list will be the same just in a different sort order.

GeorgeAWSOME · Answer

Its fine now, thanks. I didnt have 2 days to do it so I just had to swap everything myself. The point of the post was really to see if there is a way to swap numbers around, but it looks like its harder than it sounds.

RayH · Answer

Glad you got it sorted.

But its only hard because of the lack of detail in the question.
What we need are details, examples, expected outcome. Sample files. etc etc.
If all of this information was included in the first place I'm pretty sure you'd have had a solution fairly quickly.
We are not mindreaders.

Excel copy and paste

5 responses

Similar discussions

Subscribe To Our Newsletter!