May 09 2019 02:16 AM
hello, I'm new to excel..how to sort this data to individual columns..
thanks
May 09 2019 04:40 AM
@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.