hey guys...as my name says I am a complete novice but need to sort some data urgently
I have a problem I hope someone here can help me with...I have a single column of data about 1500 rows long that I need to sort from a - z...
the problem is that the letters of the data that I need to sort alphabeticaly...are preceeded by a group of numbers which in some rows their are 5 numbers before the letters & in other rows their are 6 numbers... this is throwing off the results of the a-z sort...
My question is their anyway I can use excel to just sort the letters & ignore the numbers?
any help would be greatly appreciated
regards
Bookmarks