Sorting data at end of cell
 

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.

Sorting data at end of cell
 

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


"Copper" wrote:

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.

Sorting data at end of cell
 

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

Sorting data at end of cell
 

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.

Copper wrote:
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.

Sorting data at end of cell
 

Thanks for the feedback.

Pete