Sorting data at end of cell

C

Copper

Wanting sort to be done by data of end of cell in column D for example. Is
there an easy way of doing this? Not an expert with spreadsheets by any means.
Thanks.
 
E

Elkar

The easiest way would probably be to insert a new column next to D and
extract the portion of data that you want to sort on. For example, if you
wanted to sort based on the last 4 characters in Column D, you'd enter this
formula in the new column:

=RIGHT(D1,4)

Then perform your sort on this new column.

HTH,
Elkar
 
P

Pete_UK

Do you mean you have characters or numbers at the end of your data, and
you want to sort on these rather than the full data? You can use RIGHT(
) in an extra column to extract a certain number of characters from the
data in another column, and then include this column in your sort range
and sort on this column. After the sort you can delete the extra
column.

Hope this helps.

Pete
 
C

Copper

Thanks guys, worked like a charm. Can't believe it was that easy. Like I
said, not an expert by any means. Great forum, great responses. Again
thanks.
 
Top