View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
luvsdogz
 
Posts: n/a
Default Can you sort a column by text going right to left?

THANK YOU!!!!!!!!!!!!! Works like a charm!
Aimee

"Rowan Drummond" wrote:

If all your data is in that format in an unused column you could enter
the formula:
=Right(A1,2)
Then copy down and sort on this new column

Hope this helps
Rowan

luvsdogz wrote:
I am trying to sort a by column, but want the sort to start with the right
side of the column-for example
1234gk-want to sort by kg4321 or really just gk, but I thought I could get
right to left easier.
I don't want to go thru the whole sheet to delete the numbers