convert random list to alphabetical A-Z list

janus67

Board Regular
Joined
Nov 26, 2006
Messages
141
Office Version
2016
Platform
Windows
I have a list of stock codes in randomised say A's ( out of order) , then B's etc and want to convert it to a
strict A--Z list
within each letter

in other words, make it a proper A--Z list

can some assist please
thanks
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
22,956
Put the entries in a column of cells and use Excel's standard Sort feature.
 

Forum statistics

Threads
1,089,184
Messages
5,406,688
Members
403,102
Latest member
mark 1960

This Week's Hot Topics

Top