I want to rearrange the column in excel with numbers in terminal dogit order.
for an example
i want it in
now its in numerical order eg 00001
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