Thread: reverse order
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lamb Chop
 
Posts: n/a
Default reverse order

How to reverse the order of a series of cells.

for example,

A1 = abc
A2 = efc
A3 = b96
A4= 934

to become:

B1=934
B2 =b96
B3 =efc
B4 =abc


The contents of the cells do not have any pattern and I cannot use sort etc.


Thanks

Man