sort column by last digit

K

Kepf

Lets say I have a column like:

12435G
19995
188884G
188465
277745
etc etc etc

...and I want to sort it so that the ones that end with the letter G
are isolated. Is there a way to do this?
 
B

Bob Phillips

In a helper column, add

=IF(RIGHT(A1)="G","G","")

then sort by the helper column.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top