View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Concha94
 
Posts: n/a
Default Can I sort a column of #s Rt to left? in a worksheet

I have a series or land parcel IDs. They are vertical in a column. I want to
sort them from right to left digits in the cell instead of the usual Rt to
left.

Example: Row 1. 076 88 0013
Row 2 1104 87 2311
Row 3 232 443 3779
Row 4 1167 225 B991

I want to sort ,based on the last four digits in the cell in a
Decending/Ascending as needed.

Example Row 1. 1104 87 2311
Row 2 1167 225 B991
Row 3 076 88 0013
Row 4 232443 3779

Thanks any help would be appreciated