Using Data filter function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to sort the following by entries ending in a letter only and not a integer:
1C235
1C136A
1W236B
1C239
3E563
2E106D
I need help on setting up the criteria in Data/Filter or some otherdata sort function. Any suggestions
 
Here's an option that might start you in the right direction. I'm no
saying its the best but I think it could work

Assuming the data is starting in A1 and going down column A. try makin
a new column(B) and entering:

=Right(A1,1) [this will count one character from the right and enter i
in the cell]

then sort by column B and it will seperate the letters from th
numbers.

at this point you could right click on the heading of column B an
select Hide (if you don't want it to show)

You should now be left with your your data seperated.

If you needed it sorted further you could always unhide column B an
move data around and sort like normal, but you would have to make sur
you sort by B first.

Hope it helps a little
-Cla
 
I THINK THAT THE BEST WAY MIGHT BE TO REMOVE LETTER AT THE END OF TH
STRING AND PLACE IN AN INSERTED COLUMS RIGHT THEN SORT BY NUMBER AN
THEN LETTER,
tHANKS FOR YOUR INPUT,
NEVAN
 
Back
Top