convert random list to alphabetical A-Z list

janus67

Board Regular
Joined
Nov 26, 2006
Messages
135
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
 

mikerickson

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

Forum statistics

Threads
1,077,849
Messages
5,336,736
Members
399,100
Latest member
darcob

Some videos you may like

This Week's Hot Topics

Top