View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
curlydave curlydave is offline
external usenet poster
 
Posts: 206
Default I need to rearrange the information in a column. Help?

On Feb 26, 12:47*pm, lbrown wrote:
I need to sort the data in the column by the last few digits in the column
and not the first few. Is this possible?


You could use a helper column, in column B use this formula and copy
it down
=RIGHT(A2,3)*1
The select A1 and go to data=sort and sort by column B