L
Legacy 33122
Guest
I have a column of data with both straight numbers & numbers with a letter of the alphabet attached to it. i.e.
1.1
1.1a
1.2
1.2a
When I sort this column it keeps the numbers at the top and then sends the numbers with alphabetical letters to the bottom of the sort. Is there anyway to get the sort to place them in numbers and then letters as above?
1.1
1.1a
1.2
1.2a
When I sort this column it keeps the numbers at the top and then sends the numbers with alphabetical letters to the bottom of the sort. Is there anyway to get the sort to place them in numbers and then letters as above?