to sort column

I want to rearrange the column in excel with numbers in terminal dogit order.

for an example

i want it in

00001

00011

00011

00111

01111

00021

now its in numerical order eg 00001

00011

00021

00111

please help me to make a formula to re arrage the excel in correct format. the excel that i have is more than 19600 columns

 

By: joble

Leave a Reply

Your email address will not be published. Required fields are marked *