Sorting data in Excel

Copper Contributor

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.