View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Horizontal numeric order

"Catana" wrote:
I am trying to arrange zip codes in horizontal numeric order so I can read
them like reading a paragraph in a book. How to do this please?


One thought. Assume data in A2:A10. Copy the range, then right-click on say,
B1 Paste special Check "Transpose" OK. This will paste it horizontally
into B1:J1.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---