I have two columns I want to sort. I want it to look exactly like below with Column A first sorted by its first two letters, then by Column B.

Column A     -    Column B
AB - Info         3339876
AB - Data         3339877  
AB - Data         3339878 
AC - Info         3339123
AC - Data         3339124
AC - Info         3339125
AD - Info         3339456
AD - Info         3339457
AD - Data         3339458

The first two letters of Column A are the MOST important and must be sorted by them first. The information after the first two letters of Column A is irrelevant and does not matter. It is much more important that the Column B # data to be sorted in ascending order second (after the first two letters of column A)

Sorry for the confusion. Hopefully that clears things up.

Sort normally by highlighting the column and Hit <kbd>Alt</kbd> + <kbd>A</kbd> + <kbd>SA</kbd>


Update:

'Excel sorts alphanumeric text left to right, character by character', so it may not properly order your numbers if combined into a single cell. You should create an extra column with just the two letter code that you want to use for sorting by using =LEFT(A2,2) and copying all the way down. Then do a multilayered sort by clicking the sort button, sorting first on the two digit code alphabetically and second on the number column:

example