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.