Home

Sorting data in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-551737%22%20slang%3D%22en-US%22%3ESorting%20data%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-551737%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%2C%20I'm%20new%20to%20excel..how%20to%20sort%20this%20data%20to%20individual%20columns..%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-551737%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-552119%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20data%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-552119%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F338977%22%20target%3D%22_blank%22%3E%40Chandra_sekhar_A%3C%2FA%3E%26nbsp%3B%2C%20I%20guess%20you%20didn't%20type%20these%20values%2C%20you%20import%20them%20from%20some%20external%20source.%20Better%20to%20adjust%20such%20importing%20process%20to%20have%20data%20in%20proper%20form.%20If%20importing%20is%20just%20copy%2Fpaste%2C%20when%20it%20could%20be%20Paste%20special%2C%20as%20Unicode%20text%2C%20etc.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOtherwise%20you%20may%20try%20Data-%26gt%3BText%20to%20Columns%20with%20fixed%20width.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Chandra_sekhar_A
Occasional Visitor

hello, I'm new to excel..how to sort this data to individual columns..

thanks

1 Reply

@Chandra_sekhar_A , I guess you didn't type these values, you import them from some external source. Better to adjust such importing process to have data in proper form. If importing is just copy/paste, when it could be Paste special, as Unicode text, etc.

 

Otherwise you may try Data->Text to Columns with fixed width.

Related Conversations