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

You could insert a helper column to parse off the digits you want and then
sort on the helper column.

Insert a new column to the left of the data
Let's say you want the last 3 digits. Use RIGHT(A1,3) and copy the formula
down the column.

Now you can do your sort on the helper column.
--
Kevin Backmann


"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?